how to rest identity columns in sql server
Answers were Sorted based on User's Feedback
Answer / muthu kumar
create table t(id int identity(seed,increment))
where seed is starting number and increment is number to be
incremented.
create table t(id int identity(1,1),name varchar(50))
so the id will be start with 1 and will be incremented 1 by
1 each time when record is get insered
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / adhi
USE AdventureWorks;
GO
DBCC CHECKIDENT ("HumanResources.Employee", RESEED, 300);
GO
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / yvbchowdary
The identity is similar to squence object in oracle. syntax
for identity column is
<column-name> <data type> identity(start value,increment)
ex:
empno int identity(100,2)
suppose if u want to add an odd value i.e, 50; u can also
add
first execute IDENTITY_INSERT ON
and then u can insert whatever values u want. then again
execute IDENTITY_INSERT OFF
Is This Answer Correct ? | 0 Yes | 0 No |
How will you know when statistics on a table are obsolete?
Explain how to integrate the ssrs reports in application?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
You want to implement the one-to-one relationship while designing tables. How would you do it?
Where to find ntwdblib.dll version 2000.80.194.0?
what is cluster and nin-cluster index?
What is the tcp/ip port on which sql server runs?
Why we use trigger in sql server with example?
How to connect php with different port numbers?
What is Lock table in SQL?
How to write character string constants or literals in ms sql server?
Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance