Sp in sql server

Stored procedure
A sp is group of T-SQL statement. If you have any kind of situation, where you are writing the 
same query over and over again, you can save that specific query as a 
stored procedure and then just call by it's name. Basically wrapped this query into sp, and just call that sp.

e.g.
CRETAE PROCEDURE Procedure_Name
AS 
BEGIN
  SQL Statement
END

Similar codes

2 votes308 views2 answers
Postgres drop column if exists
SQL
20 votes290 views4 answers
Reset auto increment in MySQL
SQL
2 votes284 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote324 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote307 views1 answer
Mssql + bit + in python orm
SQL
1 vote299 views1 answer
Sql how to duplicate a table
SQL
0 vote320 views1 answer
Postgres can integer fields be negative
SQL
3 votes274 views1 answer
Difference sql vs mysql
SQL
3 votes317 views4 answers
Ubuntu stop mysql
SQL
3 votes339 views1 answer
What is having
SQL