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 are the new features in SQL Server 2005 when compared to SQL Server 2000?

875


What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

826


What do you mean by normalisation?

703


what is database replication? : Sql server database administration

746


What are the triggers in sql?

774


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

818


What are a scheduled jobs?

722


Why we use trigger in sql server with example?

727


Can we use pragma autonomous_transaction in trigger?

721


What is a recursive stored procedure in sql server?

814


What is the query and subquery?

830


What happens if null values are involved in comparison operations?

739


What are sql azure firewall rules?

97


Can you explain what is indexed view? How to create it?

726


Where the sql logs gets stored?

742