在sql server数据库中已经将该字段设为自增字段,可是在插入数据时,没有自增,请教高手指点。
插入语句如下:
set IDENTITY_INSERT tcl_cs_base on
INSERT INTO TCL_CS_BASE
( ORG_C,CL_CID,CID,RRNO,CNM,CEOBNM,BDAY,BDAY_LCAL_YN,CS_CIDCD,HOME_PSNO,HOME_ADDR,
HOME_TNO, OFFC_PSNO,OFFC_ADDR,OFFC_TNO,OFFC_FAXN,OFFC_NM,DPNM,CS_JIKWI,
MOVE_TNO,ETC_TNO,EMAIL_ADDR, DM_SEND_C,TEL_DSPT_C,TEL_DSPT_FBID_YN,FAX_DSPT_FBID_YN,
DM_DSPT_FBID_YN,EMAIL_DSPT_FBID_YN, SS_DSPT_FBID_YN,EKND_NOTI_FBID_YN,REG_MN_USID,
REG_PATH_C,LAST_CHNG_MN_USID, HOME_ADDR_1,HOME_ADDR_2,HOME_ADDR_3,
OFFC_ADDR_1,OFFC_ADDR_2,OFFC_ADDR_3,LAST_CHNG_DT,COMP_CD)
VALUES
('001',@@identity,'320482198810124605','',N'dfghj',N'','19881012','','','',N'','','',N'',
'15810222306','',N'','','',N'','','','','','','','','','','','mpcmain3','PT','mpcmain3'
,N'',N'',N'',N'',N'',N'',getdate(),'MP01')
set IDENTITY_INSERT tcl_cs_base off
插入语句如下:
set IDENTITY_INSERT tcl_cs_base on
INSERT INTO TCL_CS_BASE
( ORG_C,CL_CID,CID,RRNO,CNM,CEOBNM,BDAY,BDAY_LCAL_YN,CS_CIDCD,HOME_PSNO,HOME_ADDR,
HOME_TNO, OFFC_PSNO,OFFC_ADDR,OFFC_TNO,OFFC_FAXN,OFFC_NM,DPNM,CS_JIKWI,
MOVE_TNO,ETC_TNO,EMAIL_ADDR, DM_SEND_C,TEL_DSPT_C,TEL_DSPT_FBID_YN,FAX_DSPT_FBID_YN,
DM_DSPT_FBID_YN,EMAIL_DSPT_FBID_YN, SS_DSPT_FBID_YN,EKND_NOTI_FBID_YN,REG_MN_USID,
REG_PATH_C,LAST_CHNG_MN_USID, HOME_ADDR_1,HOME_ADDR_2,HOME_ADDR_3,
OFFC_ADDR_1,OFFC_ADDR_2,OFFC_ADDR_3,LAST_CHNG_DT,COMP_CD)
VALUES
('001',@@identity,'320482198810124605','',N'dfghj',N'','19881012','','','',N'','','',N'',
'15810222306','',N'','','',N'','','','','','','','','','','','mpcmain3','PT','mpcmain3'
,N'',N'',N'',N'',N'',N'',getdate(),'MP01')
set IDENTITY_INSERT tcl_cs_base off
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货