...

Did you know that table variables are stored in the tempdb database for execution scope only?. Ok. Let us run this code declare @t table(i int) select * from tempdb.INFORMATION_SCHEMA.TABLES The result is TABLE_CATALOG TABLE_SCHEMA TA...

Did you know that table variables are stored in the tempdb database for execution scope only?. Ok. Let us run this code declare @t table(i int) select * from tempdb.INFORMATION_SCHEMA.TABLES The result is TABLE_CATALOG TABLE_SCHEMA TA...

We know that it is impossible to access a temporary table from within a user define function e.g., the following script will fail --Checks if the #Temp table exists or not and if so drops it IF OBJECT_ID('tempdb..#Temp') IS NOT NULL BEGIN Drop Ta...