How to handle inserting value to Identity column in sql server 2005# Database - 数据库
C*r
1 楼
帮朋友一问，朋友很早以前大学时候入过党，现在做博士后。现在通过EB1A申请绿卡。
党员那项填yes是不是很麻烦？通过率很低？一般这种情况可以填No吗？会有什么后果
吗？谢谢。
党员那项填yes是不是很麻烦？通过率很低？一般这种情况可以填No吗？会有什么后果
吗？谢谢。
l*b
2 楼
Hi, friends,
I have existed DB with Identity (1,1) primary key columns and it has huge
data. Now I have to insert non-auto-increment value in this primary key. Do
you have any idea on this?
I have existed DB with Identity (1,1) primary key columns and it has huge
data. Now I have to insert non-auto-increment value in this primary key. Do
you have any idea on this?
k*n
3 楼
就写没入过党,没人查的
a9
4 楼
set xxx off?
2005
Do
【在 l*****b 的大作中提到】
: Hi, friends,
: I have existed DB with Identity (1,1) primary key columns and it has huge
: data. Now I have to insert non-auto-increment value in this primary key. Do
: you have any idea on this?
2005
Do
【在 l*****b 的大作中提到】
: Hi, friends,
: I have existed DB with Identity (1,1) primary key columns and it has huge
: data. Now I have to insert non-auto-increment value in this primary key. Do
: you have any idea on this?
l*b
5 楼
Do you mean SET IDENTITY_INSERT XXX ON?
Does it have any issue if I wrap it in my high volume transactions?
【在 a9 的大作中提到】
: set xxx off?
:
: 2005
: Do
Does it have any issue if I wrap it in my high volume transactions?
【在 a9 的大作中提到】
: set xxx off?
:
: 2005
: Do
a9
6 楼
对，就是那个。我没在生产上用过，不知道。我就是在dts里用。
我也不知道手工insert以后，再自动的时候identity是几，呵呵。
【在 l*****b 的大作中提到】
: Do you mean SET IDENTITY_INSERT XXX ON?
: Does it have any issue if I wrap it in my high volume transactions?
我也不知道手工insert以后，再自动的时候identity是几，呵呵。
【在 l*****b 的大作中提到】
: Do you mean SET IDENTITY_INSERT XXX ON?
: Does it have any issue if I wrap it in my high volume transactions?
i*a
7 楼
Should be fine
【在 l*****b 的大作中提到】
: Do you mean SET IDENTITY_INSERT XXX ON?
: Does it have any issue if I wrap it in my high volume transactions?
【在 l*****b 的大作中提到】
: Do you mean SET IDENTITY_INSERT XXX ON?
: Does it have any issue if I wrap it in my high volume transactions?
l*b
8 楼
I have another approach to change the PK column Identity (1,1) to non-auto-
increment. It looks like I have to create some temp columns or tables to
copy/remove/rebuilt the PK column. Do you think I could have other way to go
? Thank you.
increment. It looks like I have to create some temp columns or tables to
copy/remove/rebuilt the PK column. Do you think I could have other way to go
? Thank you.
i*a
9 楼
are you trying to do this while the DB is live and busy?
auto-
to go
【在 l*****b 的大作中提到】
: I have another approach to change the PK column Identity (1,1) to non-auto-
: increment. It looks like I have to create some temp columns or tables to
: copy/remove/rebuilt the PK column. Do you think I could have other way to go
: ? Thank you.
auto-
to go
【在 l*****b 的大作中提到】
: I have another approach to change the PK column Identity (1,1) to non-auto-
: increment. It looks like I have to create some temp columns or tables to
: copy/remove/rebuilt the PK column. Do you think I could have other way to go
: ? Thank you.
l*b
10 楼
Hi, iMaJia, yes, I want to test if it is feasible. But I am afraid of the
performance and the role issue (need DDLadmin role as least). Do you have
other concern?
Otherwise, I have to change the PK column totally with clone/drop/rebuild.
【在 i****a 的大作中提到】
: are you trying to do this while the DB is live and busy?
:
: auto-
: to go
performance and the role issue (need DDLadmin role as least). Do you have
other concern?
Otherwise, I have to change the PK column totally with clone/drop/rebuild.
【在 i****a 的大作中提到】
: are you trying to do this while the DB is live and busy?
:
: auto-
: to go
i*a
11 楼
that maybe a problem if you have concurrent inserts into the database
from different sources.
the auto ID will insert as the next biggest number in the column. so if
you manually set indentity_insert xxx off and adds a row of ID 1000,
next auto insert will be 1001. and when you process your manual row of
1001, you'll get the error.
one way to avoid this, that I can think of now is, reserver a gap for
yourself.
say your current ID is 1 - 1000, and you need to manually insert 500
records. reseed t
【在 l*****b 的大作中提到】
: Hi, iMaJia, yes, I want to test if it is feasible. But I am afraid of the
: performance and the role issue (need DDLadmin role as least). Do you have
: other concern?
: Otherwise, I have to change the PK column totally with clone/drop/rebuild.
from different sources.
the auto ID will insert as the next biggest number in the column. so if
you manually set indentity_insert xxx off and adds a row of ID 1000,
next auto insert will be 1001. and when you process your manual row of
1001, you'll get the error.
one way to avoid this, that I can think of now is, reserver a gap for
yourself.
say your current ID is 1 - 1000, and you need to manually insert 500
records. reseed t
【在 l*****b 的大作中提到】
: Hi, iMaJia, yes, I want to test if it is feasible. But I am afraid of the
: performance and the role issue (need DDLadmin role as least). Do you have
: other concern?
: Otherwise, I have to change the PK column totally with clone/drop/rebuild.
i*a
12 楼
as for performance, do it in small batches to avoid big impact on the live
activity
the
have
clone/drop/rebuild.
【在 l*****b 的大作中提到】
: Hi, iMaJia, yes, I want to test if it is feasible. But I am afraid of the
: performance and the role issue (need DDLadmin role as least). Do you have
: other concern?
: Otherwise, I have to change the PK column totally with clone/drop/rebuild.
activity
the
have
clone/drop/rebuild.
【在 l*****b 的大作中提到】
: Hi, iMaJia, yes, I want to test if it is feasible. But I am afraid of the
: performance and the role issue (need DDLadmin role as least). Do you have
: other concern?
: Otherwise, I have to change the PK column totally with clone/drop/rebuild.
相关阅读
JVM verison of Oracle 9.2Has anybody used Sybase? Urgent help!OK, found the right tool.请问哪里有sql语句追踪工具SQL Server查询页面处理问题考MCDBA还是ORACLE的证书？graphical db design and schema design问一道几何题谁有常见Database interview questions?明白Re: AW and Shuke Re: Can I...Data warehousing Certification?query操作谁在Fedora Core2 上安装过oracle 9.2.0.4?switchboard怎么建立啊？[转载] Help: how to modify DBF file by C++mysql怎么绕过嵌套查询？unixODBCHow To Retrieve This Record? 谢谢Perl安装DBD::oracle的问题(linux,server不在本机）help on Oracle pleasewhat is AARCZ