SELECT ISVName, WebSite, Address, ZipCode, City
FROM ISVBase
WHERE (ISVName LIKE '%' + @ISVName + '%') or (City LIKE @City)我如果只写WHERE (ISVName LIKE '%' + @ISVName + '%')没有错但是都写上就查询不到结果了,怎么回事啊???
FROM ISVBase
WHERE (ISVName LIKE '%' + @ISVName + '%') or (City LIKE @City)我如果只写WHERE (ISVName LIKE '%' + @ISVName + '%')没有错但是都写上就查询不到结果了,怎么回事啊???
WHERE (ISVName LIKE '%' + @ISVName + '%')
union all
SELECT ISVName, WebSite, Address, ZipCode, City FROM ISVBase
WHERE (City LIKE @City)
SELECT ISVName, WebSite, Address, ZipCode, City
FROM ISVBase
WHERE (ISVName LIKE '%' + @ISVName + '%')
UNION ALL
SELECT ISVName, WebSite, Address, ZipCode, City
FROM ISVBase AS ISVBase_1
WHERE (City LIKE @City)两个参数默认值都为空,查询不到结果
set @isvname=''
declare @city varchar(10)
set @city=''
SELECT ISVName, WebSite, Address, ZipCode, City
FROM ISVBase
WHERE (ISVName LIKE '%' + @ISVName + '%') or (City LIKE '%'+@City+'%')--这样呢查询出来吗?
你可以select @city看一下传进来的是什么样子的值
FROM ISVBase
WHERE (ISVName LIKE =@ISVName=) or (City =@City)这样写就没有问题,好奇怪,但是我需要like
declare @isvname varchar(10)
set @isvname=' '
declare @city varchar(10)
set @city=' '
SELECT ISVName, WebSite, Address, ZipCode, City
FROM ISVBase
WHERE (ISVName LIKE '%' + replace(@ISVName,' ','') + '%') or (City LIKE replace(@City,' ',''))drop table ISVBase
用trim(rtrim(变量)),isnull(变量,'')
set @stemp="SELECT ISVName, WebSite, Address, ZipCode, City FROM ISVBase WHERE (ISVName LIKE '%' + @ISVName + '%')"
exec(@stemp)
FROM ISVBase
WHERE (ISVName LIKE '%' + ISNULL(@ISVName,'') + '%') or (City LIKE ISNULL(@City,''))--
SELECT ISVName, WebSite, Address, ZipCode, City
FROM ISVBase
WHERE (ISVName LIKE '%' + replace(@ISVName,' ','') + '%') or (City LIKE '%'+replace(@City,' ','')+'%')
SELECT ISVName, WebSite, Address, ZipCode, City
FROM ISVBase
WHERE (ISVName LIKE '%@ISVName%') or (City LIKE @City)
set @isvname=''
declare @city varchar(10)
set @city=''
SELECT ISVName, WebSite, Address, ZipCode, City
FROM ISVBase
WHERE (ISVName LIKE '%' + @ISVName + '%') or (City LIKE '%'+@City+'%')
xeqtr1982(ShaKa)()
真是个热心人。配服ing