sql - 存储过程 - 选择然后插入

Question

我是编码存储过程的新手。基本上我只想将表 1 的前 10 条记录转移到表 2(我创建的)。我的代码无法插入我从表 1 中选择的记录。我不确定是我遗漏了什么还是我做错了。请帮忙。提前致谢!

注意:

1.) 表 1 和表 2 具有相同的数据类型。

2.) 我需要每一列的参数，以便我能够在我的 c#.net 图中调用它们

这是我的SP:

**

USE [GDW]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[sp_BI_Get_AsiaTopTen]

AS BEGIN
  DECLARE 
  @fyname nvarchar(120),
  @fmonth nvarchar(120),
  @fmonth_num int = null,
  @world_area nvarchar(120) = null

    SELECT TOP 10 
  @fyname= [FYName], 
  @fmonth= [FMONTH], 
  @fmonth_num= [FMONTH_NUM],
  @world_area= [World_AREA]
  FROM [dbo].[tbl_BI_FastReport1_Temp]
  WHERE [World_AREA] = 'Asia'
  AND [FMONTH_NUM] = '201401'

  INSERT INTO [dbo].[tbl_BI_AsiaTopTen]
  (
  [FYName],
  [FMONTH],
  [FMONTH_NUM],
  [World_AREA]
  )
  VALUES
  (
  @fyname,
  @fmonth,
  @fmonth_num,
  @world_area
  )

  END

**

Answer 1

ALTER PROCEDURE [dbo].[sp_BI_Get_AsiaTopTen]
AS 
BEGIN
  SET NOCOUNT ON;

      INSERT INTO [dbo].[tbl_BI_AsiaTopTen]
                      ([FYName],[FMONTH],[FMONTH_NUM],[World_AREA])
    SELECT TOP 10 [FYName] 
                , [FMONTH] 
                , [FMONTH_NUM]
                , [World_AREA]
    FROM [dbo].[tbl_BI_FastReport1_Temp]
    WHERE [World_AREA] = 'Asia'
    AND [FMONTH_NUM] = '201401'
 -- ORDER BY SomeCOlumn 
END