一个插入数据的问题

[猿敲月下码]

表中主键是自增型的,但是现在有个需求要强行插入一个自定义主键

有这方面的sql吗? 还是在插入前需要设置什么的?

[billpu]

set identity_insert tb on

[billpu]

记录插入后再关闭即可
set identity_insert tb off

[「已注销」]

SET IDENTITY_INSERT TB ON

SET IDENTITY_INSERT TB OFF

[猿敲月下码]

感谢LS~ 下班钱结贴.来着有分哦~

[ws_hgo]

# --(2)当设置identity_insert选项值为 ON的时候,可以插入id.  
# create table #te  
# (  
#   id int identity(1,1),  
#   col1 varchar(10)  
# )  
# insert into #te values ('aa')  
# insert into #te values ('bb')  
# select * from #te  
# set identity_insert #te on  
# insert into #te(id,col1) values (10,'ff')  
#   
# set identity_insert #te off  
# insert into #te values ('hh')  
# --(3)当使用identity_insert插入一个最小的id,之后在在插入新的值,不会以那个小的值进行递增的  
# create table #TF  
# (  
#   id int identity(1,1),  
#   col1 int  
# )  
# insert into #TF select 1  
# union all select 2  
# union all select 3  
#   
# set identity_insert #TF on  
# insert into #TF (id,col1) select 1,10  
# set identity_insert #TF off  
# insert into #TF select 4  
# select * from #TF  

[ws_hgo]

http://blog.csdn.net/ws_hgo/archive/2009/02/06/3866850.aspx

[hao1hao2hao3]

[Quote=引用 4 楼 thc1987 的回复:]
感谢LS~ 下班钱结贴.来着有分哦~
[/Quote]

那就接分了。

[fengyun142415]

学习

[cnwolfwind]

学习来了

[qq574444572]

[Quote=引用 3 楼 zsh0809 的回复:]
SQL code
SET IDENTITY_INSERT TB ON

SET IDENTITY_INSERT TB OFF
[/Quote]

[zhangdoublepan]

SET IDENTITY_INSERT TB ON

SET IDENTITY_INSERT TB OFF

[jxmlearner]

学习,顺便接个分!

[abuying]

--插入前
SET IDENTITY_INSERT TB ON
--插入后
SET IDENTITY_INSERT TB OFF

[张家可]

SET IDENTITY_INSERT TB ON

insert into TB values(......)
SET IDENTITY_INSERT TB OFF

[lxq19851204]