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 行)
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 行)
caixia615(紫瞳) :你意思说类型错误?可是它表里面原来的数据都是这个形式的,我改字段类型的话,说需要这个列为空才行