SQL server 利用存储过程怎么判断一个表是否存在
create procedure proName
@TableName NVARCHAR(50)
as
begin
if object_id(N'表名',N'U') is null --判断表是否存在
print (0)
else
print (1)
create procedure proName
@TableName NVARCHAR(50)
as
begin
select(
select
OBJECT_ID
from sys.tables
where name = @TableName
) ;
end
alter procedure A
@table_name NVARCHAR(50)
as
begin
Declare
@sql nvarchar(256)
select @sql = STUFF ((select object_id(N''+@table_name+'',N'U') FOR XML PATH('')), 1, 1, '')
if @sql <>0 --判断表是否存在
print '表存在'
else
print '表不存在'
end
浙公网安备 33010602011771号