SQL Server Question (Way OFF TOPIC SORRY)

From: "Mirko Geffken" <mgeffken(at)corcoranweb(dot)com>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: SQL Server Question (Way OFF TOPIC SORRY)
Date: 2000-07-05 19:34:29
Message-ID: NEBBKOEPOMFJCEFFDFKPAEHPCAAA.mgeffken@corcoranweb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I know this is way off topic (with this being a PostgreSQL mailing list),
but I couldn't find one.

Does anyone know of a SQL Server mailing list.

In case anybody knows the answer here, here is my question:
I want to insert into a table with an identity field and get the identity
field's value returned immediately
e.g.
CREATE TABLE x
(
id IDENTITY(1,1),
y INT
);

INSERT INTO x(y) VALUES (2)

In Oracle you can do something like:
x:=INSERT INTO x(y) VALUES (2) RETURNING id (forgot exact syntax)

Does anyone know of a safe (meaning works with concurrent users) solution for SQL Server?

Thanks for your time and I apologize for the off topic message
Mirko

Browse pgsql-general by date

  From Date Subject
Next Message Steven Saner 2000-07-05 19:42:22 Need help with error
Previous Message Mike Sears 2000-07-05 19:22:25 newbie question