判断当前数据库的名称
代码:
DECLARE @maDbName SYSNAME
IF (DB_NAME() LIKE N'%Test')
BEGIN
SET @maDbName = N'MemberArchiveTest'
END
ELSE
BEGIN
SET @maDbName = N'MemberArchive'
END
代码释义:如果当前数据库是以test结尾,就进行相应的设置
判断数据库中某个库是否存在:
EXISTS (SELECT 1 FROM master.dbo.sysdatabases WHERE [name] =databasename)
判断某张表是否存在
select 1 from sys.tables where OBJECT_ID=OBJECT_ID('TableName',N'U')
and EXISTS (SELECT 1 FROM master.dbo.sysdatabases WHERE [name] ='DatabaseName')
判断某张表中某个字段是否存在:
EXISTS (SELECT 1 FROM sys.columns WHERE [object_id] = OBJECT_ID(N'dbo.Tr_Role', N'U')
AND [name] = N'MembershipNumber')