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

How do you size a resultset?

0 Answers  

Explain DBCC?

0 Answers   QuestPond,

what is a join and explain different types of joins? : Sql server database administration

0 Answers  

How many full-text indexes can a table have?

0 Answers  

How do I list the available tables in a database I'm querying?

4 Answers  

what is the cursor life span?

5 Answers   Evalueserve, HG,

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

Are all views updatable ?

0 Answers   MCN Solutions,

Difference between DELETE and TRUNCATE?

0 Answers   TCS,

What does dml stand for?

0 Answers  

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,

For more SQL Server Interview Questions Click Here
Categories