CREATE PROCEDURE sp_AA @tbl_Name VarChar(16), @Col_Name VarChar(16), @Col_Value VARCHAR(16)
AS
declare @s nvarchar(4000),@bResult bit
set @s='IF EXISTS (SELECT '+@Col_Name+' FROM '+@tbl_Name+' WHERE '+@Col_Name+' ='''+ @Col_Value+''') set @re=1 else set @re=0'
exec sp_executesql @s,N'@re bit out',@bResult out
select @bResult
go
AS
declare @s nvarchar(4000),@bResult bit
set @s='IF EXISTS (SELECT '+@Col_Name+' FROM '+@tbl_Name+' WHERE '+@Col_Name+' ='''+ @Col_Value+''') set @re=1 else set @re=0'
exec sp_executesql @s,N'@re bit out',@bResult out
select @bResult
go
set @a=1
else
set @a=0'exec sp_executesql @sql,N'@a bit output',@bResult output
select @bResult 结果