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

0 vote294 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote187 views1 answer
Insert into select with group by
SQL
10 votes177 views1 answer
Dba_dependencies
SQL
1 vote178 views1 answer
Oracle start job
SQL
13 votes170 views2 answers
Mysql order by multiple columns
SQL
0 vote142 views2 answers
Spring properties file for db
SQL
1 vote178 views1 answer
Table information in sql server
SQL
1 vote191 views1 answer
Postgresql filter on
SQL
0 vote212 views1 answer
Oracle list dblink
SQL
4 votes184 views2 answers
Oracle drop job
SQL