create proc sp_SearchInfo
@key nvarchar(20),
@pageindex int =1
as
exec sp_Pagination 'products','id,productname,indeximg,content','id','48',1,'1','1', 'productname like ''%' +str(@key)+ '%'' '报错....报+号附近有语法错误!
@key nvarchar(20),
@pageindex int =1
as
exec sp_Pagination 'products','id,productname,indeximg,content','id','48',1,'1','1', 'productname like ''%' +str(@key)+ '%'' '报错....报+号附近有语法错误!
@key nvarchar(20),
@pageindex int =1
as
exec sp_Pagination 'products','id,productname,indeximg,content','id','48',1,'1','1', 'productname like ''%' +str(@key)+ '%' '
'productname like ''%' +@key+ '%'''
@key nvarchar(20),
@pageindex int =1
asdeclare @where varchar(100)set @where ='productname like ''%' + str(@key) + '%'''exec sp_Pagination 'products','id,productname,indeximg,content','id','48',1,'1','1', @where
@key nvarchar(20),
@pageindex int =1
as
--declare @key nvarchar(20)
declare @str varchar(500)
set @str='productname like ''%'+convert(varchar(20),@key)+'%'' '
exec sp_Pagination 'products','id,productname,indeximg,content','id','48',1,'1','1', @str
--参数可以可以是表达式
@key nvarchar(20),
@pageindex int =1
as
declare @tmp nvarchar(1000)
set @tmp= 'productname like ''%' +str(@key)+ '%'' '
exec sp_Pagination 'products','id,productname,indeximg,content','id','48',1,'1','1',@tmp