改为下面代码试试: CREATE PROCEDURE u_getbrand @emporiumid int AS declare @brandlist varchar(8000) select @brandlist=brandlist from emporium where emporiumid=@emporiumidif not (@brandlist=' ' or @brandlist is null) select @brandlist=''''+isnull(@brandlist,'')+'''' select brandname,brandid,logo from brand where @brandlist like '%'''+convert(varchar(10),brandid)+'''%' order by newid()go
CREATE PROCEDURE u_getbrand
@emporiumid int
AS
declare @brandlist varchar(8000)
select @brandlist=brandlist from emporium where emporiumid=@emporiumidif not (@brandlist=' ' or @brandlist is null) select @brandlist=''''+isnull(@brandlist,'')+''''
select brandname,brandid,logo
from brand
where @brandlist like '%'''+convert(varchar(10),brandid)+'''%'
order by newid()go