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 are the different types of replication you can set up in sql server?
List the data types available in mssql?
Explain identity in sql server?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
How to get the query of a table in sql server?
Characterize join and name diverse sorts of joins?
Explain indexes disadvantages?
Why I am getting this error when renaming a database in ms sql server?
How to find table changes in sql server?
How fixed length strings are truncated and padded?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What are scalar functions in sql?
How can we rewrite sub-queries into simple select statements or with joins?
Which tools are available to manage SQL Azure databases and servers?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?