Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

how to get the last inserted Id With SQL Server

2 Posts 2 Posters 0 Views 1 Watching

A Offline
A Offline
Amit Agarrwal

wrote on last edited by

#1

hello I'm Using SQL Server 2000 for backend with my Asp.net Application. I want to get the last inserted Id in webpage any one have some suggestion Reagarding this issue.

Dotnet
D 1 Reply Last reply

0
A Amit Agarrwal

hello I'm Using SQL Server 2000 for backend with my Asp.net Application. I want to get the last inserted Id in webpage any one have some suggestion Reagarding this issue.

Dotnet
D Offline
D Offline
danidanidani

wrote on last edited by

#2

use SCOPE_IDENTITY() here is more on the subject http://aspnet.4guysfromrolla.com/articles/062905-1.aspx

Cheers, Dani
1 Reply Last reply

0

Log in to reply