Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Explain multiserver query

957


what is the difference between delete table and truncate table commands? : Sql server database administration

958


Is sql server implemented as a service or an application? : Sql server database administration

892


How to create an identity column?

1134


Introduction of rollup clause using sum and group by clause?

898


Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

912


Does sql server 2016 have ssms?

910


What is sparse columns of sql server 2008?

991


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

979


Do you know what is lock escalation?

963


How to drop existing views from a database in ms sql server?

1038


Explain the dbcc pintable command when would you use it?

865


Why use “nolock” in sql server?

979


Explain database normalization?

1147


What language is sql server written in?

981