Str1:= ' CREATE PROCEDURE CheckIsExists1 '+
' @Check_falg Char(1) output , '+
' @TableName1 Char (40)'+
' @NowFieldName1 char(60), '+
' @FieldName1 char(40) '+
'As'
'Begin'+
' if Exists(''Select * from ''+@TableName1+'' Where +''+@FieldName1+''= @NowFieldName1) '+
' Set @Check_falg=''Y'' '+
' Else Set @Check=''n'''+
' END ' ;
' @Check_falg Char(1) output , '+
' @TableName1 Char (40)'+
' @NowFieldName1 char(60), '+
' @FieldName1 char(40) '+
'As'
'Begin'+
' if Exists(''Select * from ''+@TableName1+'' Where +''+@FieldName1+''= @NowFieldName1) '+
' Set @Check_falg=''Y'' '+
' Else Set @Check=''n'''+
' END ' ;
HELP!
' @Check_falg Char(1) output , '+
' @TableName1 Char (40)'+
' @NowFieldName1 char(60), '+
' @FieldName1 char(40) '+
'As'+
'Begin'+
' if Exists(''Select * from ''+@TableName1+'' Where ''+@FieldName1+''= @NowFieldName1) '+
' Set @Check_falg=''Y'' '+
' Else Set @Check=''n'''+
' END ' ;
create procedure CheckIsExists1
@表名 varchar(100),
@列名 varchar(100),
@值 varchar(100)
as
begin
exec('
if (if Exists(Select * from '+@表名+' where '+@列名+'='''+@值+''')
select ''存在''
else
select ''不存在''
')
end