Collections:
Testing Local Temporary Stored Procedures in SQL Server
Can Another User Execute Your Local Temporary Stored Procedures in SQL Server Transact-SQL?
✍: FYIcenter.com
Can another user execute your local temporary stored procedures? The answer is no.
To test this out, continue with the exercise from the previous tutorial. Keep that user session running and open a new client session with sqlcmd.exe. Then run the tutorial script below:
-- Executing permanent procedure -- created by another user session EXECUTE Hello 'fyicenter.com'; GO Welcome to moc.retneciyf -- Executing local temporary procedure -- created by another user session EXECUTE #Hello 'fyicenter.com'; GO Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure '#Hello'.
⇒ Using User Defined Functions in SQL Server Transact-SQL
⇐ Creating Local Temporary Stored Procedures in SQL Server
2016-12-28, 1408🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...