Stored Procedures

stored procedures: a stored procedure is a group of transact sql statements that act as a single block of code that performs specific task. types of stored procedures: 1)system stored procedures 2)extended stored procedures 3)temporary stored procedures 4)remote stored procedures 5)local stored procedures 6)custom stored procedures(user defined stored procedures) system stored procedure : all system stored procedures start with "sp_" ex:sp_tables ex:sp_indexes @ table_server = "student;=" creation of custom stored procedure : syntax: create procedure <procedurename> (@parameter datatype) as sql commands ex: create procedure p1 as select * from tablename; Executing or running stored procedure ex: execute p1;