22,209
社区成员
发帖
与我相关
我的任务
分享
ALTER proc [dbo].[Proc_Decide_Field]
/** 判断表中是否存在某字段 **/
( @xTable Nvarchar(20),
@xField Nvarchar(20),
@M smallint output)
AS
Begin
declare @Sql as varchar(max)
set @Sql='
if exists(select * from PREVIOUS_FILE..syscolumns where id=object_id('+
'''PREVIOUS_FILE.dbo.'+@xTable+''''+') and Name='+''''+@xField+''''+')
set @M=1
else
set @M=0'
print @Sql
exec sp_executesql @Sql,N'@M int out',@M out
print @M
end
declare @Sql as varchar(max)
将varchar改为 nvarchar
Select Count(Name) as cnt FROM SysColumns Where id=Object_Id(@xTable) and Name = @xField
cnt = 1 表示存在该字段.