create proc see
@ok nvarchar (50)
as
declare @strSQL nvarchar
set @strSQL ='select * from Thread where postsID not in ('+@ok+')'
-- 存储过程。execute see @ok='5'
-- 调用,为什么只返回 ‘命令已成功完成’。为什么没结果的。?
@ok nvarchar (50)
as
declare @strSQL nvarchar
set @strSQL ='select * from Thread where postsID not in ('+@ok+')'
-- 存储过程。execute see @ok='5'
-- 调用,为什么只返回 ‘命令已成功完成’。为什么没结果的。?
@ok nvarchar (50)
as
declare @strSQL nvarchar(4000)
set @strSQL ='select * from Thread where charindex(rtrim(postsID), '+@ok+')<0'
exec(@strSQL)
-- 存储过程。execute see @ok='5'
改成这样
@ok nvarchar (50)
as
declare @strSQL nvarchar
set @strSQL ='select * from Thread where postsID not in ('+@ok+')'
EXEC(@STRSQL)
-- 存储过程。execute see @ok='5'
@ok nvarchar (50)
as
declare @strSQL nvarchar(4000)
set @strSQL ='select * from Thread where charindex(rtrim(postsID), '+@ok+')=0'
exec(@strSQL)
-- 存储过程。execute see @ok='5'
这样
@ok nvarchar (50)
as
declare @strSQL nvarchar
set @strSQL ='select * from Thread where postsID not in ('+@ok+')'
exec (@strSQL)
go-- 存储过程。execute see @ok='5'
@ok nvarchar (50)
as
select * from Thread where CHARINDEX(','+postsID+',',','+@OK+',')>0 execute see @ok='5'
@ok nvarchar (50)
as
select * from Thread where charindex(rtrim(postsID),@ok)=0
-- 存储过程。execute see @ok='5'
这样也可以的
@ok nvarchar (50)
as
select * from Thread where charindex(','+rtrim(postsID)+',',','+@ok+',')=0
-- 存储过程。execute see @ok='5'
完善下
charindex 是=0吧
--都不行。。
--我这样才行。 create proc see
@ok nvarchar (50)
as
declare @strSQL nvarchar(4000)--这里要有个字符长度哦。呵呵。不然不行
set @strSQL ='select * from Thread where postsID not in ('+@ok+')'
exec(@strSQL)exec see @ok='5'
@ok nvarchar (50)
as
exec ('select * from Thread where postsID not in ('''+@ok+''')')
-- 存储过程。
goexecute see '5'
not in (5)那就是全都调出来了。