如题. 另外请教如何结贴给分!~
解决方案 »
- 查询出俩表的不同纪录
- 求SQL日期取最近的语句
- 求:ddl触发器保存位置
- BCP 处理命令行时出错
- 请问如何在update触发器中执行 insert?
- 求助:一个MS-SQL触发器的写法(高手请进)
- SQL server 2000 如何导入流媒体
- 有关top percent的困惑,请高手答疑
- 关于SQL SERVER2005复制代理作业错误信息
- Subquery returned more than 1 value. This is , update operator ,update table ...,thanks a lot!
- sql2000 insert触发器问题
- !!!!!distinct引发的问题!!!!!!
declare @sql varchar(100)
set @a='!=32,!=35'
set @a=replace(@a,'!=','!=''')
set @a=replace(@a,',',''' and [ID]')
set @sql='select * from [Table] where [ID]'+@a+''''
exec(@sql)
declare @sql varchar(max)
set @a='!=32,!=35,!=38'
set @a=replace(@a,',!=',''',''')
set @a=replace(@a,'!=','''')
set @sql='select * from TB where company not in ('+@a+''')'
--print @sql
exec(@sql)
declare @sql varchar(1000)
select @a='!=32,!=35'
select @a=replace(@a,'!=','''')
select @a=replace(@a,',',''',')+''''
select @sql='select * from tabname where company not in ('+@a+')'
exec(@sql)
(id int)
insert into #
select 23 union all
select 32 union all
select 35 declare @a varchar(100)
declare @sql varchar(100)
set @a='!=32,!=35'
select @a=replace(@a,'!=','')
select @a=replace('select '+@a,',',' union select ')
select @sql='select * from # where id not in ('+@a+')'
--print @sql
exec(@sql)/*
id
-----------
23*/