jinlibing914的专栏

BULK Insert dbo.Rpt_Statistic_All From 'c:\Rpt_Statistic_temp20070719.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' )   

 declare @t table ( tid int, tv char(1) ) insert into @t select 1,'a' union all select 1,'a' union all select 2,'b' union all sel...

/*0 1 2*/select 'insert into [USER_PLAY_LOG] select '+cast(USER_ID as nvarchar(20))+','''+cast(FIRST_PLAY as nvarchar(20))+''','''+cast(LAST_PLAY as nvarchar(20))+''';'from [TEMP_USER_PLAY_LOG]wher...