What are the rules to use the rowguidcol property to define a globally unique identifier column?



What are the rules to use the rowguidcol property to define a globally unique identifier column?..

Answer / Waseem Khan

When defining a globally unique identifier (GUID) column using the ROWGUIDCOL property in SQL Server, follow these guidelines:
1. The column should be defined as a uniqueidentifier data type.
2. The column should not allow NULL values.
3. The column should not have a default value.
4. The column should be included in the primary key or unique constraint.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are Sql Reporting Services and analysis services? Can u Explain

1 Answers  


Explain what is “asynchronous” communication in sql server service broker?

1 Answers  


What is the need for group functions in sql?

1 Answers  


Explain about service Broker functions?

1 Answers  


Write the Syntax for Cursors.

2 Answers   CarrizalSoft Technologies, HP,


How to execute stored procedure in select statement sql server?

1 Answers  


How to read 2nd highest sal from EMP table?

5 Answers   IBM, TCS,


How to genrate automaticlly empid like gt001

4 Answers  


What is the language structure to add a record to a table?

1 Answers  


Explain about SQL server 2005?

1 Answers  


wat is tuff file in log shipping, wt is d use of tht file?

1 Answers   TCS,


What is enhanced database mirroring in sql server 2008?

1 Answers  


Categories