如何在azure sql数据库中设置标识 [英] How to set the identity in azure sql database
问题描述
大家好,
我在microsoft sql azure中有一张表作为emp(empid主键,身份,sal,dept)。
我插入了10个值,如:
empid sal dept
1 2000 3
2 3000 2
3 500 1
。 ......
。 ......
。 ....
10 2000 3
现在我从5到10删除了empid。
现在我正在插入新的值,它从11作为pid(因为我给了empid作为身份)。
现在问题是如何从6重置empid身份。
请任何身体帮助我如何实现这个....
提前致谢......... 。
注:
i尝试如下:
1)DBCC CHECKIDENT('emp',RESEED,6)
2)SET IDENTITY_INSERT OFF
插入emp(empid,sal,dept)值(6,3800,5)
SET IDENTITY_INSERT ON
i尝试上述方式但未获得解决方案。所以任何身体帮助我以另一种方式做到这一点。
你必须在身份插入中添加表名
SET IDENTITY_INSERT员工ON
插入INTO员工....
SET IDENTITY_INSERT员工OFF
Link
Hi all,
I have a table in microsoft sql azure as emp(empid primary key,identity,sal,dept).
I inserted 10 values like:
empid sal dept
1 2000 3
2 3000 2
3 500 1
. ... .
. ... .
. ... .
10 2000 3
Now I deleted empid from 5 to 10.
Now I am inserting new values it's empid taking from 11 as pid(because i given empid as identity).
now the problem is how can i reset the empid identity from 6.
please any body help to me how can achieve this....
Thanks in advance..........
NOTE:
i tried like below:
1)DBCC CHECKIDENT('emp',RESEED,6)
2) SET IDENTITY_INSERT OFF
insert into emp(empid,sal,dept) values(6,3800,5)
SET IDENTITY_INSERT ON
i tried above to-ways but not get solution. so any body help to me how to do this in another way.
You have to add the table name in identity insert
SET IDENTITY_INSERT employee ON
Insert INTO employee....
SET IDENTITY_INSERT employee OFF
Link
这篇关于如何在azure sql数据库中设置标识的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!