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.....................
Saturday, January 16, 2010
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment