存储过程示例+SQL语句

set ANSI_NULLS ON  
set QUOTED_IDENTIFIER ON  
go  
 
  
ALTER     procedure [sp_analysislog_test]  
as  
declare @sql varchar(200)  
set @sql='bulk insert tb_analysislog_test1 from ' + '''C:\extend4249.csv'' with ( FIELDTERMINATOR = ''\t'', ROWTERMINATOR = ''\n'', MAXERRORS=1000 )'     
exec(@sql)  
  
set ANSI_NULLS ON  
set QUOTED_IDENTIFIER ON

exec sp_analysislog_test// 执行  

// 删除某表
truncate table 
dbo.tb_analysislog_test1


// 命令版
bulk insert tb_analysislog_test1 from 'C:\extend4249.csv' with ( FIELDTERMINATOR = '\t', ROWTERMINATOR = '\n', MAXERRORS=1000 )  
 
排序：
SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC, OrderNumber ASC