Replace Tempdb tables with ##tables
Temp db Tables behavior is different
between Sybase and SQL Server. In Sybase such tables exist till end
of the owner session or explicit drop but in SQL server it will exist
till explicit Drop. In Sybase Temp table created like
tempdb.schema.temptable.
To achieve same functionality Global temp table
should be used so that the temp table is visible across all
Sessions and Exist till end of the owner session or explicit drop. In
SQL server temp table created like ##temptable. Preferably drop temp
tables like below. I have placed Sybase equivalent SQL server scripts
for create and dropping tables.
No comments:
Post a Comment