Question

存储过程中怎样为查询语句追加条件

急求

Answer 1

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
--exec SP_ProcName N'1'
create proc SP_ProcName

@p1 char(2)='0'
as

begin
declare @sql nvarchar(2000)
set @sql='select *from a where id='+@p1
exec(@sql)
end

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO