Hi all,
Can anybody help me to create query , to find out the key_id(primary key)
for the last saved record.
Key_id is not sequential it can be any random no.
Any help will be appreciated.
Thanx
Printable View
Hi all,
Can anybody help me to create query , to find out the key_id(primary key)
for the last saved record.
Key_id is not sequential it can be any random no.
Any help will be appreciated.
Thanx
well if you will search MSDN or even MS SQL Book, you will find the way to create a stored procedure which will return the ID after insertion.
be a little lazy to do a search. ;)
Andy
use : sqlite_last_insert_rowid()
http://www.sqlite.org/faq.html#q1