34,590
社区成员
发帖
与我相关
我的任务
分享
declare @NAME varchar(50) --定义变量来保存ID号
declare @sql varchar(8000)
declare mycursor cursor for SELECT name FROM SYSOBJECTS WHERE TYPE='U' and name like '%_ASD_%' --为所获得的数据集指定游标
open mycursor --打开游标
fetch next from mycursor into @NAME --开始抓第一条数据
while(@@fetch_status=0) --如果数据集里一直有数据
begin
set @sql='delete '+@NAME +' where _time < ''2009-2-5'''
fetch next from mycursor into @NAME --跳到下一条数据
exec(@sql)
end
close mycursor --关闭游标
deallocate mycursor --删除游标
declare @NAME nvarchar(50)
declare mycursor cursor for SELECT name FROM SYSOBJECTS WHERE TYPE='U'
open mycursor
fetch next from mycursor into @NAME
while(@@fetch_status=0)
begin
delete FROM [Table1].[dbo].str(@NAME) where _time< '2009-2-5'
fetch next from mycursor into @NAME
end
close mycursor
deallocate mycursor
declare @NAME varchar(50) --定义变量来保存ID号
declare @sql varchar(8000)
declare mycursor cursor for SELECT name FROM SYSOBJECTS WHERE TYPE='U' and name like '%_ASD_%' --为所获得的数据集指定游标
open mycursor --打开游标
fetch next from mycursor into @NAME --开始抓第一条数据
while(@@fetch_status=0) --如果数据集里一直有数据
begin
set @sql='delete '+@NAME +' where _time < ''2009-2-5'''
fetch next from mycursor into @NAME --跳到下一条数据
end
close mycursor --关闭游标
deallocate mycursor --删除游标
declare @s varchar(8000)
declare @name varchar(100)
declare cur cursor for select name FROM SYSOBJECTS WHERE TYPE='U'
open cur
fetch from cur into @name
while @@fetch_status=0
begin
set @s='delete '+@name +' where _time < ''2009-2-5'''
print @s
exec(@s)
fetch next from cur into @name
end
close cur
deallocate cur
declare @NAME nvarchar(20) --定义变量来保存ID号
declare mycursor cursor for SELECT name FROM SYSOBJECTS WHERE TYPE='U' and name like '%_ASD_%' --为所获得的数据集指定游标
open mycursor --打开游标
fetch next from mycursor into @NAME --开始抓第一条数据
while(@@fetch_status=0) --如果数据集里一直有数据
begin
delete FROM @NAME where _time< '2009-2-5' --开始做想做的事(什么更新呀,删除呀)
fetch next from mycursor into @NAME --跳到下一条数据
end
close mycursor --关闭游标
deallocate mycursor --删除游标
SELECT USER_ID()
delete from sysobjects where
uid = 1 and crdate < '2009-2-5' and xtype ='U'