Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Is this a good unique table name ?

Author  Topic 

orozcoc
Starting Member

13 Posts

Posted - 2002-09-20 : 14:16:20
cast(@@PACK_RECEIVED as varchar) + cast(@@PACK_SENT as varchar)

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-09-20 : 14:21:19
Could be. What context are you using it in? If it's meant to keep multiple users from colliding on the same table at the same time, then this can fail. Regular temp tables can accomplish that goal without needing unique names...each temp table is isolated from other connections.

And before you say "I don't want to use temp tables for performance reasons", exactly how will creating a non-temp table perform better?

Go to Top of Page
   

- Advertisement -