放哨De老鼠

摘要： create proc [dbo].[sp_test1]as begin declare test cursor scroll for --声明游标select id,ordernumber from tb_order--给游标赋值open test --打开游标declare @id intdeclare @c varchar(100)while @@FETCH_STATUS=0 --利用@@FETCH_STATUS来循环begin fetch next from test into @id,@cinsert into tb_error(Message,TableNames)values(@ 阅读全文