Mega Code Archive

 

Categories / MSSQL Tutorial / System Tables Views

 

Verifying the existence of the default database

14> 15>     CREATE PROC pr_verifydb (@dbname varchar(30)) 16>     AS 17>     DECLARE @dbid int 18>     SELECT @dbid = dbid from sysdatabases 19>          where name = @dbname 20>     IF @@rowcount = 0 21>          RETURN 50 22>     RETURN 0 -- Everything is perfect!!! 23>     GO 1> 2>