Data Pouring or Recommended BCPIF EXISTS (Select * from Tempdb..sysObjects where id = Object_id (n'Tempdb .. # t ') Drop Table [#t]
Create Table #t (ID Int IDETENTITY (1, 1) Not Null, Remark Varchar (8001) NULL) INSERT INTO #TEXEC MASTER.DBO.XP_CMDSHELL 'TYPE E: /DATA.TXT' SELECT * FROM # t 剩 靠You own according to the "Data Type", "data format", etc. .....
