how to get rank of diffrent student in same table based on
newly inserted row in sql server2008
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 |
Post New Answer View All Answers
What is 4nf in normalization form?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
What are types of subqueries?
How do you trace the traffic hitting a sql server?
What is the order by used for?
Where actually sql azure database is hosted?
Can sql server be linked with other servers like oracle?
Why do we need normalization?
How to locate and take substrings with charindex() and substring() functions?
Explain datetime2 data type in sal server 2008?
What happens if an integer is too big for int date type?
What are the three different part of rdl file explain them?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
What are translations and its use? : sql server analysis services, ssas
what is new philosophy for database devises for sql server 7.0? : Sql server database administration