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

Explain about protocol layer present in SQL server?

0 Answers  

How to transfer Logins from SQL Server 2000 to 2005

2 Answers  

What are the new features in SQL Server 2005?

3 Answers   Emphasis,

What is sorting and what is the difference between sorting and clustered indexes?

1 Answers  

What kind of problems occurs if we do not implement proper locking strategy?

0 Answers  

What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  

How do I view views in sql server?

0 Answers  

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.

0 Answers  

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

Difference between primary key and clustered index?

0 Answers  

What is the default Port No on which SQL Server listens?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories