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 |
Define msdb database?
Why use triggers?
Are null values the same as that of zero or a blank space?
Why are sql functions used?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
what is hash table
What are the different normalization forms?
Comment,Datatypes are unlimited
Describe and explain about SQL native client?
What is difference between getdate and sysdatetime in sql server 2008?
What is difference between views and stored procedures?
Why do we need normalization?
Oracle (3253)
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)