插入数据
declare @strsql varchar(8000),@i int
declare @userid int,@username varchar(50)declare @mycursor cursor
set @mycursor=cursor for SELECT userid,username FROM Dv_User
open @mycursor
select @@fetch_status
fetch next from @mycursor into @userid,@username
while @@fetch_status=0
begin
set @strsql='INSERT INTO aa (ID,Partname) VALUES('+convert(varchar(4),@userid)+','''+@username+''' )'
print @strsql
fetch next from @mycursor into @userid,@username
end
----关闭游标------
close @mycursor
deallocate @mycursor
日期:'''+convert(varchar(20),@JoinDate,120)+'''
更新数据
declare @strsql varchar(8000),@i int,@d smalldatetime,@r smalldatetime,@f varchar(7000)
declare @AnnounceID int
declare @Body varchar(7000)
declare @mycursor cursor
set @mycursor=cursor for SELECT AnnounceID, cast(Body as varchar(7000)) body FROM dv_bbs1
open @mycursor
select @@fetch_status
fetch next from @mycursor into @AnnounceID,@Body
while @@fetch_status=0
begin
set @strsql='UPDATE dnt_posts1 set message='''+cast(@Body as varchar(7000))+''' where pid='+convert(varchar(6),@AnnounceID)+''
print @strsql
fetch next from @mycursor into @AnnounceID,@Body
end
----关闭游标------
close @mycursor
deallocate @mycursor
declare @Body varchar(7000)
declare @mycursor cursor
set @mycursor=cursor for SELECT AnnounceID, cast(Body as varchar(7000)) body FROM dv_bbs1
open @mycursor
select @@fetch_status
fetch next from @mycursor into @AnnounceID,@Body
while @@fetch_status=0
begin
set @strsql='UPDATE dnt_posts1 set message='''+cast(@Body as varchar(7000))+''' where pid='+convert(varchar(6),@AnnounceID)+''
print @strsql
fetch next from @mycursor into @AnnounceID,@Body
end
----关闭游标------
close @mycursor
deallocate @mycursor