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, 1769🔥, 0💬
Popular Posts:
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...