Store procedure in SQL server

Question

Hi Is there any limit in number of statements that can be used in store procedures?

Priya Linge · Answer

Hi A stored procedure is a group of Transact-SQL statements compiled into a single execution plan. 1.The maximum size of a stored procedure is 128 MB. 2. A stored procedure is a set of SQL statements that can be stored in the server 3.Stored procedures provide SQL enhancements that support variables comments declarative statements conditional testing and looping as programming elements. They have full access to SQL DML statements allowing a multitude of command types; they cannot however execute DDL statements i.e. a stored procedure cannot create a table. Please check below link. http://ibexpert.net/ibe/index.php?n=Doc.StoredProcedure Hope this will help you. Thanks.

Satyapriya Nayak · Answer

Hi prashant Please refer the below link http://msdn.microsoft.com/en-us/library/aa258259%28v=sql.80%29.aspx Thanks