Collections:
Creating Local Temporary Stored Procedures in SQL Server
How To Create a Local Temporary Stored Procedure in SQL Server Transact-SQL?
✍: FYIcenter.com
A local temporary stored procedure is a special stored procedure that:
This tutorial exercise here creates two stored procedures, one is permanent and the other is local temporary:
DROP PROCEDURE Hello; DROP PROCEDURE #Hello; GO CREATE PROCEDURE Hello @url nvarchar(40) AS PRINT 'Welcome to ' + REVERSE(@url); GO CREATE PROCEDURE #Hello @url nvarchar(40) AS PRINT 'Welcome to ' + @url; GO EXECUTE Hello 'fyicenter.com'; GO Welcome to moc.retneciyf EXECUTE #Hello 'fyicenter.com'; GO Welcome to fyicenter.com
2016-12-28, 708👍, 0💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...