22,206
社区成员
发帖
与我相关
我的任务
分享
ALTER PROCEDURE [dbo].[s_sp_Getprovince]
@provincesql nvarchar(50)
AS
BEGIN
select distinct * from tblProvince where 1=1 + @provincesql
END
exec s_sp_Getprovince 'and zid=bj'
ALTER PROCEDURE [dbo].[s_sp_Getprovince]
@provincesql nvarchar(50)
AS
BEGIN
exec('select distinct * from tblProvince where 1=1 '+ @provincesql)
END
--TRY
ALTER PROCEDURE [dbo].[s_sp_Getprovince]
@provincesql nvarchar(50)
AS
BEGIN
EXEC('select distinct * from tblProvince where 1=1' + @provincesql)
END
ALTER PROCEDURE [dbo].[s_sp_Getprovince]
@provincesql nvarchar(50)
AS
BEGIN
exec('select distinct * from tblProvince where 1=1 '+ @provincesql)
END
ALTER PROCEDURE [dbo].[s_sp_Getprovince]
@provincesql nvarchar(50)
AS
BEGIN
exec('select distinct * from tblProvince where 1=1 '+ @provincesql)
END