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
What authentication modes does sql server support?
What is default constraint?
Does group by or order by come first?
What is inline variable assignment?
How to list all triggers in the database with sys.triggers in ms sql server?
Is sql server a database?
What is a dbms wizard?
Is sql server difficult to learn?
How do you delete a trigger?
How to create an index on an existing table in ms sql server?
Data table as parameter in sql server?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
State a few properties of relational databases?
What is a system database and what is a user database?
How to update muliple row in single query?