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 are wait types?
What is the boxing and unboxing concept in .net?
How much memory that we are using in Logshipping Concept?
What options are available to audit login activity? : sql server security
How can you control the amount of free space in your index pages?
Explain about protocol layer present in SQL server?
what is the main function of a query parameter?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What are triggers in ms sql server?
What is the difference between varchar and nvarchar?
What do you understand by recursive stored procedure?
What is the purpose of a table?
What are advantages of ssrs or why we should use ssrs?
What is the optimization being performed in oracle and SQL Server?
Write a SQL command to insert and update only a particular field?