如何将打印数据插入另一个表？ [英] how insert print data to another table ?

问题描述

您好我是sql sever 2008 r2的新手。我创建了如下所示的存储过程。我想插入所有记录，但它只存储一条记录

Hi i am new to sql sever 2008 r2 . i was created stored procedure like this given below . i want to insert all the records but it was storing only one record

 create PROCEDURE [dbo].[StudentDEtails]
	-- Add the parameters for the stored procedure here
	@Id varchar(40)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	
	DECLARE         @section			varchar(50),
			@Postion			varchar(50),
			@Rating				int,
			@marks				varchar(50),
			@Date		datetime,
			@Score			int,
			@class				varchar(50),
			@Signature		varchar(50),
			@Remarks			varchar(50),
			@subject_Types		varchar(50),
			@Initial_Grade		int,
			@strSQL				varchar(200),
                        @roll_Number              int,
			@xx                       int,
                        @yy                       int;
			
			
	DECLARE @MyCursor CURSOR; 

-- DELETE ALL EXISTING RECORDS FROM APPLICATION_FIRE
	TRUNCATE TABLE APPLICATION_FIRE;
	
-- Get Practice and Posttion
	
	SET @MyCursor = CURSOR FAST_FORWARD 
	FOR Select 	id,Date, Score, Initial_Grade, Class(i mean it is  1st class ,2rd class..etc ), signature,Remarks
	FROM DBO.sTudentinfo WHERE id = @id; 
			   	
	OPEN @MyCursor 
	FETCH NEXT FROM @MyCursor 
	INTO @id, @Date, @Score, @Initial_Grade, @Class, @Signature, @Remarks

	WHILE @@FETCH_STATUS = 0 
	BEGIN 
       
	    PRINT @Army_number
		PRINT @Section
		PRINT @Postion
		PRINT @rating
		PRINT @marks 
		PRINT @Date
		PRINT @Score
		PRINT @class
		PRINT @signature
		PRINT @Remarks
	        PRINT @Initial_grade
		PRINT @subject_Type
		
		-- GET PRACTICE, POSITION,rating,marks 
		SELECT @section = Type_Of_section, @Postion = Position, @rating = rating,@marks=marks,@subject_Types=subject_Types FROM DBO.studentmoreinfo WHERE yy_ID = @yy_Id AND
		roll_Number = @roll_Number AND xx_ID = @xx_ID;  
		
		
		
		
	   FETCH NEXT FROM @MyCursor 
	       INTO @id, @Date, @Score, @Initial_grade, @class, @signature, @Remarks
	
	 
  
	
END 

CLOSE @MyCursor 
DEALLOCATE @MyCursor 

这是显示输出这样的输出

this was excuting shows output like this

 1
 mar 7 2013 11:13 AM 
 0
 T.H
 1
 Af
 0
 
1

 
Mar 17 2013 11:13AM
1
0
2
fas
0
 
1

 
Mar 17 2013 11:13AM
0
0
3
fa
0
 
1
 
 
 
 
Mar 17 2013 11:13AM
1
0
2
fas
0

这个我希望发送给另一个表名表是studentbasicinfo



i写了这样的查询

this oupt i want to sent to another table table name i s studentbasicinfo

i was wrote a query like this

insert into ([id],[section],[postion],[rating][marks][date][score],[class],[signature],[remarks],[subject_Types],[initila_grade]
values (@id,@section,@postion,@rating,@marks,@date,@Score,@calss,@signature,@remarks,@subject_Type,@initial_Grade)

这是执行的，它只有一行.Actuvally它有3排。我想把所有的排都送到那张桌子怎么样？所以PLZ帮我

this was excuted and it sotring only one row .Actuvally It has 3 row. iwant to sent all the row to that table how? so plz help me

推荐答案

你好b $ b试试这个

Hi Try This

CREATE PROCEDURE [dbo].[StudentDEtails]
	-- Add the parameters for the stored procedure here
	@Id varchar(40)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
	
	DECLARE   @section varchar(50), @Postion varchar(50),@Rating int, @marks varchar(50), @Date datetime,
			@Score int, @class varchar(50), @Signature varchar(50),@Remarks varchar(50),@subject_Types varchar(50),
			@Initial_Grade	int,@strSQL varchar(200),@roll_Number int,@xx int,@yy int;
			
	DECLARE @MyCursor CURSOR; 
 
-- DELETE ALL EXISTING RECORDS FROM APPLICATION_FIRE
	TRUNCATE TABLE APPLICATION_FIRE;
	
-- Get Practice and Posttion
	
	SET @MyCursor = CURSOR FAST_FORWARD 
	FOR Select id,Date, Score, Initial_Grade, Class(i mean it is  1st class ,2rd class..etc ), signature,Remarks
	FROM DBO.sTudentinfo WHERE id = @id; 
			   	
	OPEN @MyCursor 
	FETCH NEXT FROM @MyCursor 
	INTO @id, @Date, @Score, @Initial_Grade, @Class, @Signature, @Remarks
 
	WHILE @@FETCH_STATUS = 0 
	BEGIN 
	    PRINT @Army_number
		PRINT @Section
		PRINT @Postion
		PRINT @rating
		PRINT @marks 
		PRINT @Date
		PRINT @Score
		PRINT @class
		PRINT @signature
		PRINT @Remarks
	     PRINT @Initial_grade
		PRINT @subject_Type
		
		-- GET PRACTICE, POSITION,rating,marks 
		SELECT @section = Type_Of_section, @Postion = Position, @rating = rating,@marks=marks,@subject_Types=subject_Types FROM DBO.studentmoreinfo WHERE yy_ID = @yy_Id AND
		roll_Number = @roll_Number AND xx_ID = @xx_ID;  
		
	    insert studentbasicinfo into ([id],[section],[postion],[rating][marks][date][score],[class],[signature],[remarks],[subject_Types],[initila_grade]
	    values (@id,@section,@postion,@rating,@marks,@date,@Score,@calss,@signature,@remarks,@subject_Type,@initial_Grade)
		
	   FETCH NEXT FROM @MyCursor INTO @id, @Date, @Score, @Initial_grade, @class, @signature, @Remarks
    END 
 
    CLOSE @MyCursor 
    DEALLOCATE @MyCursor 
END

问候，

GVPrabu

Regards,
GVPrabu

这篇关于如何将打印数据插入另一个表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！