SQL Server Temp Table Persistence - STORED PROCEDURES
Discussion of Temporary Tables, Persistence and STORED PROCEDURES. Temp Tables are created in the tempdb system database in SQL Server. They are persistent but not necessarily long lived, particularly when executing a store procedure that has its own unique connection to SQL Server. Temp tables are created with strange looking table names that are actually unique instances of the hash mark named table that are related via the specific connection to SQL Server, whether it be through a query window or a stored procedure.
On this page of the site you can watch the video online SQL Server Temp Table Persistence - STORED PROCEDURES with a duration of hours minute second in good quality, which was uploaded by the user SQL University 28 February 2014, share the link with friends and acquaintances, this video has already been watched 1,435 times on youtube and it was liked by 3 viewers. Enjoy your viewing!
