在一个表中增加新的记录

    declare cur_insert cursor for
    SELECT 
       [Number]
      ,[orderID]
      ,[Title]
      ,[notice]
      ,[Author]
      ,[MainBody]
      ,[YNUPDATE]
      ,[YNVIEW]
      ,[CreateTime]
      ,[Items]
  FROM [MROPRDB].[dbo].[C_Notice] where notice='销售类' and Site='CCT'
 
  open cur_insert
   declare @Number nvarchar(20),
   @orderID nvarchar(10),
   @Title nvarchar(20),
   @notice nvarchar(50),
   @Author nvarchar(50),
 
   @MainBody nvarchar(max),
   @YNUPDATE  int,
    @YNVIEW int ,
    @CreateTime datetime,
    @Items nvarchar(200)
   
  
 
  fetch next from cur_insert into @Number,@orderID,@Title,@notice,@Author,@MainBody,@YNUPDATE,@YNVIEW,@CreateTime,@Items
 
   while(@@fetch_status=0)
 begin
    insert into  [MROPRDB].[dbo].[C_Notice](Number,[orderID],[Title],[notice],[Author],[Site],[MainBody],[YNUPDATE],[YNVIEW],[CreateTime],[Items])
    values(@Number,@orderID,@Title,@notice,@Author,'MMD-DS',@MainBody,@YNUPDATE,@YNVIEW,GETDATE(),@Items)
   
      fetch next from cur_insert into @Number,@orderID,@Title,@notice,@Author,@MainBody,@YNUPDATE,@YNVIEW,@CreateTime,@Items
 
 end
 close cur_insert
 deallocate cur_insert