@@identity

[bbawa1]

Hi,

I have a table in which I have four columns.

ID (primary Key)
FirstName,
LastName,
Email

I want to add another column as @@identity in this already existing
table.

How can I do that.

 

[Patrice]

Not sure what you meant by "add a column as @@identity" ?

If you meant you want to add a new IDENTITY column use ALTER TABLE MyTable
INT IDENTITY NOT NULL.

If you meant you want to add another identity column this is just not
possible (makes no sense anyway).

If you meant to use @@identity to feed a column, it shouldn't cause any
problem. What have you tried ?

You may want to explain what you are trying to do for better sugegstion...

 

[Guest]

Suggest try one of the SQL server newsgroups. This is for ASP.NET