Answer Posted / 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 View All Answers
Are resultset updatable?
How many ways to create table-valued functions?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What is indexing and its types?
What is blocking?
Why should you use or avoid select * statements?
Explain what are page splits? : SQL Server Architecture
What is buffer cash in sql server?
When a primary key constraint is included in a table, what other constraints does this imply?
What is the contrast amongst drop and truncate?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
What are page splits? : SQL Server Architecture
Why use “in” clause in sql server?
What is sql sandbox in sql server?
How to bind a view to the schema of the underlying tables?