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 vote254 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
5 votes225 views1 answer
Postgres upsert
SQL
0 vote214 views1 answer
Calculate discount from original price sql
SQL
1 vote260 views2 answers
Drop function in sql
SQL
6 votes247 views1 answer
Update left join mysql
SQL
0 vote306 views1 answer
Generate a random otp in sql server
SQL
0 vote269 views1 answer
Call scalar valued function sql
SQL
0 vote245 views1 answer
Mysql workbench procedure
SQL
2 votes256 views2 answers
Mysql alter column default
SQL
0 vote259 views3 answers
Osx stop mysql service
SQL