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 |
what is integrated security (SSPI). why we use in the connection string?
Explain the rules for designing files and file groups in sql server?
Which trace flags are enabled in sql server?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What are functions in the sql server?
What is pivot and unpivot?
What are the different normalization forms?
Differencr Between DELETE and TRUNCATE?
What are group functions in query statements in ms sql server?
What is user-defined functions? What are the types of user-defined functions that can be created?
Explain Geometry datatype in sql server 2008 with example
Why do we need normalization?
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)