Collections:
Creating Stored Procedures with Statement Blocks in SQL Server
How To Create a Stored Procedure with a Statement Block in SQL Server Transact-SQL?
✍: FYIcenter.com
If you are creating a stored procedure with multiple statements, it's better to use "BEGIN ... END" to group all statements into a single statement block.
The tutorial exercise below shows you some good examples:
USE FyiCenterData; GO CREATE PROCEDURE Show AS BEGIN SELECT name, type_desc FROM sys.tables; SELECT name, type_desc FROM sys.views; SELECT name, type_desc FROM sys.procedures; END; GO Command(s) completed successfully. EXEC Show; GO name type_desc ------------------- --------------------- fyi_random USER_TABLE fyi_links_indexed USER_TABLE fyi_links USER_TABLE fyi_links_copy USER_TABLE name type_desc ------------------- --------------------- fyi_links_top VIEW fyi_links_dump VIEW fyi_links_view VIEW name type_desc ------------------- --------------------- Hello SQL_STORED_PROCEDURE date SQL_STORED_PROCEDURE Show SQL_STORED_PROCEDURE
⇒ Ending Stored Procedures Properly in SQL Server
⇐ "DROP PROCEDURE" - Dropping an Existing Procedure in SQL Server
2017-01-05, 1886🔥, 0💬
Popular Posts:
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to st...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...