Saturday, January 16, 2010

Table Variables Exist in TEMPDB

Hi All,
To Prove that Table variable exists in TEMPDB Run
Select * from tempdb.Information_schema.tables where table_name like '%#%'
go
Declare @v Table(ID Int Identity Primary key nonclustered, B Int)
Insert @v Select 1
run above select command ----------Select
HEY HEY Enjoy.....................

No comments:

Post a Comment