Sql实例:
insert into DATA_PLAT_VODSHIFT_MEDIA(TERMINAL_ID,COL_PATH,START_TIME,END_TIME,FAST_FORWARD_NUM,PAUSE_NUM,REWIND_NUM,AREA_ID,AREA_NAME,
COLUMN_ID,COLUMN_NAME,PROGRAM_NAME,PROGRAM_TYPE,PROGRAM_TIME,CREATOR_ID,CREATE_TIME)
select TERMINAL_ID,COL_PATH,START_TIME,END_TIME,FAST_FORWARD_NUM,PAUSE_NUM,REWIND_NUM,AREA_ID,AREA_NAME,COLUMN_ID,COLUMN_NAME,
PROGRAM_NAME,PROGRAM_TYPE,PROGRAM_TIME,1,getdate() FROM OPENROWSET(BULK N'${fileName}',FORMATFILE=N'${formatFileName}',
MAXERRORS = ${maxErrors},ERRORFILE = N'${errorFileName}') AS t1