Answer Posted / p.s jayagopal
Identity(or Auto Number) is a column which automatically
generates numeric values.It will be mainly used for a column
which is set as primary key and which doesn't allow null value.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is catalog views?
How to use go command in "sqlcmd"?
Does full backup break log chain?
What is difference between line feed ( ) and carriage return ( )?
What are the different types of lock modes in sql server 2000?
What is sql server agent and what are the two modes of authentication in sql server?
What is unpivot?
How to create a simple user defined function in ms sql server?
How to insert and update data into a table with "insert" and "update" statements?
Explain rdbms?
Define Unique Key?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
What is merge statement?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
How to select some specific rows from a table in ms sql server?