Posted by fireball on 12/20/06 17:17

which is more proper:
if DB_ID(@db) IS NOT NULL
or
IF EXISTS (SELECT name FROM sys.databases WHERE name = @db)
?




regards

• Next in forum: sp_executesql vs. EXECUTE
• Prev in forum: Re: Backup Priority level
• Thread view: if exists condition..

[Reply to this message]