exec('if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].['+chengduimingxizhangku+']'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)
drop table [dbo].[chengduimingxizhangku]')
---------------
exec 中单引号 使用2个来代替
drop table [dbo].[chengduimingxizhangku]')
---------------
exec 中单引号 使用2个来代替
set @tbName='chengduimingxizhangku'
set @sql='if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].['+@tbName+
']'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1)'+
'drop table [dbo].['+@tbName+']'
exec(@sql)