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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

WHAT IS UNIQUE IDENTIFIER DATA TYPE?

Question Posted / ranjit kumar routhu

Answers were Sorted based on User's Feedback



WHAT IS UNIQUE IDENTIFIER DATA TYPE?..

Answer / tauseef

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 32 charcters and not 16 characters

Is This Answer Correct ?    4 Yes 2 No

WHAT IS UNIQUE IDENTIFIER DATA TYPE?..

Answer / 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

More SQL Server Interview Questions

What is the difference between DATETIME2 and DATETIME?

0 Answers   Infosys,

Which Model uses the SET concept

0 Answers   Infosys,

Explain the use of keyword with encryption. Create a store procedure with encryption?

0 Answers  

What is truncate table?

0 Answers  

Is candidate a key?

0 Answers  

Can you explain full-text query in sql server?

0 Answers  

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

Explain how does the report manager work in ssrs?

0 Answers  

How many instances per computer are there in sql server 2000?

0 Answers  

What is a natural primary key?

0 Answers  

What is a rollup clause?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories