TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Hiranya Jayathilaka
NA
2
0
Problem with IDENT_CURRENT( ) Function
Jun 26 2007 5:08 AM
I'm developing a database application with C#. My database management system is SQL server 2005. I'm using the IDENT_CURRENT( ) function to get the ID of the last inserted row in data tables.
According to the documentation IDENT_CURRENT( ) function should return null when invoked against a newly created empty table. However in my application it returns 1 for that kind of tables. Any idea why it behaves like that?
Also please do let me if there is a better way to get the last inserted ID from a data table...
Reply
Answers (
2
)
sql 2005 crystal report XI xml
SQL order by only for non empty fields