Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do. ... Call the Stored Procedure; 1] Click on New Query.