create table t_gbit_2_video(n_trial_sn char(10),n_trial_sub_sn char(10),c_ndh char(10),c_ajzh char(10),c_ajbh char(10),c_courtid char(10),d_start datetime,d_end datetime,
n_length char(10),c_multi char(20),c_result char(100),c_filepath char(100),c_filename char(100),c_judge char(100),c_tape char(100))
insert into t_gbit_2_video 
(n_trial_sn,n_trial_sub_sn,c_ndh,
c_ajzh,c_ajbh,c_courtid,d_start,d_end,
n_length,c_multi,c_result,c_filepath,c_filename,c_judge,c_tape)
 values( '3','1','2006','230911','579','14','2006-12-1 19:28:59','2006-12-1 19:29:04','5','0','3','\\172.19.200.254\data','2006_12_01_19_28_59_2006_230911_579.mp4','Judge','' )
select * from t_gbit_2_video
结果:
                                                                                       n_trial_sn n_trial_sub_sn c_ndh      c_ajzh     c_ajbh     c_courtid  d_start                                                d_end                                                  n_length   c_multi              c_result                                                                                             c_filepath                                                                                           c_filename                                                                                           c_judge                                                                                              c_tape                                                                                               
---------- -------------- ---------- ---------- ---------- ---------- ------------------------------------------------------ ------------------------------------------------------ ---------- -------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- 
3          1              2006       230911     579        14         2006-12-01 19:28:59.000                                2006-12-01 19:29:04.000                                5          0                    3                                                                                                    \\172.19.200.254\data                                                                                2006_12_01_19_28_59_2006_230911_579.mp4                                                              Judge                                                                                                                                                                                                    (所影响的行数为 1 行)