Yes
Nobody knows everything, but everybody knows something
Search This Blog
Friday, January 28, 2011
How to identify Indentiy column in a table and also max value for that Identity column
DBCC
checkident
(
tablename
)
Eg:
create table
b
(
i
int
identity
,
n
int
)
insert
into
b
select
122
union
select
135
select
*
from
b
dbcc
checkident
(
b
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment