place identity on a column at the time of creating table Ex: create tab

how to get rank of diffrent student in same table based on
newly inserted row in sql server2008

Question Posted / naveen

Answer Posted / naveen

place identity on a column at the time of creating table

Ex:
create table test(studentrank identity(1,1))

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can foreign key be deleted?

871

What is clustered primary key?

959

How to start sql server browser service?

1066

Explain aggregate functions?

1027

If a stored procedure is taking a table data type, how it looks?

6351

List the various tools available for performance tuning?

843

What is statement level trigger?

935

How to create hyperlink from returned sql query ?

1071

What is tcl in sql server?

1076

When does a workload on SQL Azure get throttled?

129

List out a number of the wants to setup a SQL Server failover cluster?

1007

Explain syntax for disabling triggers?

971

what is the information that can be stored inside a bit column? : Sql server database administration

902

What is data compression?

941

What is the usage of the sign function?

998