WHAT IS UNIQUE IDENTIFIER DATA TYPE?

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


Please Help Members By Posting Answers For Below Questions

What does COMMIT command do?

629


Can you get second highest salary from the table?

556


How would you use user_constraints table in DB?

592


What is the difference between a function and a trigger?

577


What are diverse clauses that form a part of sql?

602






Explain different types of lock modes in sql server 2000?

525


Why the trigger fires multiple times in single login?

730


What is serializable?

673


How to list all user defined functions in the current database?

518


Can you explain different types of joins?

549


whats the maximum size of view state??

1726


What are the extra roles available in msdb? : sql server security

644


What does it mean to normalize data?

524


If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

560


 Explain what is sql override for a source taLle in a mapping?

576