超长sql语句被截断?
--要插入的表为
CREATE TABLE [dbo].[B_log] (
[log_id] [int] IDENTITY (1, 1) NOT NULL ,
[LogDateTime] [datetime] NULL ,
[user_id] [int] NULL ,
[user_name] [nvarchar] (11) COLLATE Chinese_PRC_CI_AS NULL ,
[client_name] [nvarchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
[client_ip] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[op_action] [nvarchar] (21) COLLATE Chinese_PRC_CI_AS NULL ,
[op_sqlstring] [nvarchar] (1000) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[B_log] WITH NOCHECK ADD
CONSTRAINT [PK_B_log] PRIMARY KEY CLUSTERED
(
[log_id]
) ON [PRIMARY]
GO
-------------------------------------------------------
--要执行的sql语句为:op_sqlstring字段被截断
insert into b_log (LogDateTime,user_id,user_name,client_name,client_ip,op_action,op_sqlstring) values ('2006-1-23 23:19:53',1,'管理
员','MAIA2','192.168.1.95','机动车修改','veh_number=xxxxxx,struc_number=9616824,engine_number=6013126,seating=5,charact=私车,kind=小客,brand=切诺机,color=
兰,grade=,reg_date=1996-11-01,cert_date=1996-11-07,veh_settle=是,settle_date=1996-11-06,settle_end=3000-12-31,last_settle_date=2004-11-
04,next_annual_check=2006-11-01,last_annual_check=2005-11-22,next_settle_date=2006-11-06,property=,resp_number=,spe_fig=1已验内,agent=
否,who_agent=,center_insu=否,v_next_annual_insu=2005-11-09,settle_source=,emp_st_sc= -1,remark=,check_fee=0,mng_fee=240,Owner=张xxx,gender=男,birthday=1963-
08-02,ID_card=XXX1031963080XXXX,pt=13820465597,phs=,phone=0,Address=同上,Post=,id_addr=河西区大营门勤艺里(凯旋门马场道门
口),comp=,comp_phone=,comp_addr=,email=69182487,remark_owner=,sms=否,vip=否,emp_veh=50,emp_op_veh=1,op_date=2005-11-23,in_date=2006-1-23 23:19:34no_use=,no_use_date=3000-12-31,no_use_r
eason=Status=1,price_section=C,big_client=否,Insu_kind=,')
---------------------------------------------------------------
op_string字段被截断为
veh_number=xxxxxx,struc_number=9616824,engine_number=6013126,seating=5,charact=私车,kind=小客,brand=切诺机,color=兰,grade=,reg_date=1996-11-01,cert_date=1996-11-07,veh_settle=是,settle_date=1996-11-06,settle_end=3000-12-31,last_settle_date=2004-11-04,next_annual_ch
veh_number=AJ6345,struc_number=9616824,engine_number=6013126,seating=5,charact=私车,kind=小客,brand=切诺机,color=兰,grade=,reg_date=1996-11-01,cert_date=1996-11-07,veh_settle=是,settle_date=1996-11-06,settle_end=3000-12-31,last_settle_date=2004-11-04,next_annual_ch
---------如果不能执行大家调一下格式。求问,这个问题应该怎么处理?