sqlserver identity_insert 数据库插入不了

sqlserver identity_insert 数据库插入不了

--先打开IDENTITY_INSERT
set identity_insert ValueCardSet ON
--添加数据  
 insert into ValueCardSet (FlowId,BeginAmount,EndAmount,BeginDate,EndDate,SendAmount,Operator,OperDate
 )values('1','100','150',GETDATE(),GETDATE()+300,'20','ADMIN',GETDATE())

具体百度

 

posted on 2022-09-20 16:16  Jankie1122  阅读(51)  评论(0编辑  收藏  举报