WHAT IS UNIQUE IDENTIFIER DATA TYPE?
Answers were Sorted based on User's Feedback
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 |
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 |
How do you rename a table in sql server?
What types of Joins are possible with Sql Server?
What is the difference between dropping a database and taking a database offline?
What is 'write-ahead log' in sql server 2000 ?
Can an automatic recovery be initiated by a user?
Define Check points and End Points?
Can you explain full-text query in sql server?
How to use wildcard characters in like operations in ms sql server?
What is the difference between writing data to mirrored drives versus raid5 drives
how do u do Performance tunning ?
1 Answers Infodat Technologies, Satyam,
What is the difference between delete and truncate statements?
Define constraints and give an example of their use?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)