Autogeneration in MSSQL

[varunapj]

HI ,
im using mysql express 2005 , Autogeneration of numbers is possible ?

[ronverdonk]

HI ,
im using mysql express 2005 , Autogeneration of numbers is possible ?

When you mean AUTO_INCREMENT columns: yes.

Ronald

[mwasif]

Hi varunapj,

What is mysql express 2005? Are you talking about Microsoft SQL Server 2005 Express Edition?

[varunapj]

Yes my sql server 2005 which comes in visual studio 2005

[ronverdonk]

Yes my sql server 2005 which comes in visual studio 2005

This is the MySQL forum. Seen your reply you should post your question in the MS SQL forum. I will move it there.

moderator

[ck9663]

HI ,
im using mysql express 2005 , Autogeneration of numbers is possible ?

Try using the IDENTITY property of an int column.

-- Ck