Answer Posted / ranjit kumar routhu
unique identifier data type size is 16 bits.
while creating table we have to create unique identifier
datatype column. it will create unique identity column
with 16 charcters
ex: create table a( id uniqueidentifier default newid
(),....),newid() generates new 16 unique charcter values
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
Explain multiserver query
what is the difference between delete table and truncate table commands? : Sql server database administration
Is sql server implemented as a service or an application? : Sql server database administration
How to create an identity column?
Introduction of rollup clause using sum and group by clause?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Does sql server 2016 have ssms?
What is sparse columns of sql server 2008?
Do you know data definition language, data control language and data manipulation language?
Do you know what is lock escalation?
How to drop existing views from a database in ms sql server?
Explain the dbcc pintable command when would you use it?
Why use “nolock” in sql server?
Explain database normalization?
What language is sql server written in?