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

Which autogrowth database setting is good?

836


What’s the use of custom fields in report?

760


last function used in MS Access to convert sql what function will use in sql

1860


How to use subqueries with the in operators in ms sql server?

790


How do I create a stored procedure in sql server?

735


How many clustered indexes there can be on table ?

793


Detail about query optimizer?

842


What is the syntax for encrypting a column in SQL Server?

832


What are a scheduled jobs?

733


What is dirty page?

764


How to enter date and time literals in ms sql server?

724


Do you know data definition language, data control language and data manipulation language?

826


What is a deadlock and what is a live lock?

789


What is partition, how will you implement it? : sql server analysis services, ssas

840


How to replace the Query Result 'Null Value' with a text ?

810