SQL Server Question (Way OFF TOPIC SORRY)

Поиск
Список
Период
Сортировка
От Mirko Geffken
Тема SQL Server Question (Way OFF TOPIC SORRY)
Дата
Msg-id NEBBKOEPOMFJCEFFDFKPAEHPCAAA.mgeffken@corcoranweb.com
обсуждение исходный текст
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: selkovjr@mcs.anl.gov
Дата:
Сообщение: Re: Re: [ANNOUNCE] Re: [HACKERS] proposed improvements to PostgreSQL license
Следующее
От: Steven Saner
Дата:
Сообщение: Need help with error