How to retrieve a PK assigned to a table? - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

How to retrieve a PK assigned to a table?

Message

De

03/08/2005 15:35:50

Sergey Berezniker
New York, États-Unis

À

03/08/2005 15:30:01

Alan Biddle
Sungard Public Sector
High Point, Caroline du Nord, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Autre

Titre:

Re: How to retrieve a PK assigned to a table?

Divers

Thread ID:

01038224

Message ID:

01038273

Vues:

18

This message has been marked as a message which has helped to the initial question of the thread.

>Do a SELECT @@IDENTITY statement to get last PK inserted into your SQL table.

It may be safer to use SCOPE_IDENTITY(). See BOL for details.

--sb--

Click here to load this message in the networking platform