给数据库插入值是，怎样给自增加列插入值 

 
SET IDENTITY_INSERT [t_IDNotContinuous] ON
10 
11 INSERT [t_IDNotContinuous] ([ID],[ValuesString]) VALUES ( 1,'test')
12 INSERT [t_IDNotContinuous] ([ID],[ValuesString]) VALUES ( 2,'test')
13 INSERT [t_IDNotContinuous] ([ID],[ValuesString]) VALUES ( 3,'test')
14 INSERT [t_IDNotContinuous] ([ID],[ValuesString]) VALUES ( 5,'test')
15 INSERT [t_IDNotContinuous] ([ID],[ValuesString]) VALUES ( 6,'test')
16 INSERT [t_IDNotContinuous] ([ID],[ValuesString]) VALUES ( 7,'test')
17 INSERT [t_IDNotContinuous] ([ID],[ValuesString]) VALUES ( 10,'test')
18 
19 SET IDENTITY_INSERT [t_IDNotContinuous] OFF
posted @ 2015-07-21 16:26  AStronghcm  阅读(226)  评论(0)  编辑  收藏  举报