What are the rules to use the rowguidcol property to define a globally unique identifier column?
- 1 Answers
- 1116 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How do I create a trace in sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Can we shrink data file in sql server?
How to convert character strings into numeric values?
Why and when do stored procedure recompile?
How can you append an identity column to a temporary table?
what is the difference between openrowset and openquery?
How to remove duplicate rows from table except one?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is in place upgrade in sql server?
What is the primary use of the model database?
List the ways in which dynamic sql can be executed?
What is self contained sub query?
How to provide default values to function parameters?
