27,579
社区成员
发帖
与我相关
我的任务
分享
execute dbo.myPro 'status=1'
create procedure dbo.myPro
declare @strWhere varchar(1500),
declare @sql varchar(1500)
set @sql='select * from T_company where '+@strWhere
exec(@strSql)
create procedure dbo.myPro
@strWhere varchar(1500)
as
declare @sql varchar(1500)
set @sql='select * from T_company where 1 = 1 and '+@strWhere
exec(@strSql)
--print @sql
go
--只有一个条件
execute dbo.myPro 'status=1'
--如果里面有字符或者日期的,那么单引号要写2次
execute dbo.myPro 'status=1 and ceateTime>''2013-11-01 11:09:08.107'' and create<''2013-11-05 11:09:08.107'''