SQLSERVER 临时表的使用

IF OBJECT_ID('tempdb..#LXH_Temp') IS NOT NULL
    DROP TABLE #LXH_Temp;
CREATE TABLE #LXH_Temp
    (
      [Agn_ID] [NVARCHAR](4) NOT NULL ,
      BACL_CODE NVARCHAR(14) ,
      BACL_Name NVARCHAR(200)
    );


//TODO：把数据写入临时表

CREATE NONCLUSTERED INDEX IX_LXH_Temp_Agn_ID ON #LXH_Temp(Agn_ID);