我的dbo.pp_product表里有productname,introduce,imageurl,price这几列
我的储存过程只返回productname这一列,请各位大侠指点!set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[PP_GETSearchProduct]
@searchkey nVarchar(50)
AS
SELECT productname From dbo.pp_product where productname like '%'+@searchkey+'%'
我的储存过程只返回productname这一列,请各位大侠指点!set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[PP_GETSearchProduct]
@searchkey nVarchar(50)
AS
SELECT productname From dbo.pp_product where productname like '%'+@searchkey+'%'
--这样?
ALTER PROCEDURE [dbo].[PP_GETSearchProduct]
@searchkey nVarchar(50)
AS
declare @sql varchar(8000)
SELECT @sql=isnull(@sql+',','')+productname From dbo.pp_product where productname like '%'+@searchkey+'%'
select @sql
go
我的储存过程只返回产品的productname这一列
ALTER PROCEDURE [dbo].[PP_GETSearchProduct]
@searchkey nVarchar(50)
AS SELECT productname+ltrim(introduce)+imageurl+ltrim(price) From dbo.pp_product where productname like '%'+@searchkey+'%'go