if not Exists(select top 1 * from sysObjects where Id=OBJECT_ID(N'tablename') and xtype='u')
begin
set @usexec=1;
end
else
begin
set @usexec=0;
end
SQL server数据库语句 判断表是否存在
最新推荐文章于 2024-04-26 09:11:45 发布
if not Exists(select top 1 * from sysObjects where Id=OBJECT_ID(N'tablename') and xtype='u')
begin
set @usexec=1;
end
else
begin
set @usexec=0;
end