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 |
What are Sql Reporting Services and analysis services? Can u Explain
Explain what is “asynchronous” communication in sql server service broker?
What is the need for group functions in sql?
Explain about service Broker functions?
Write the Syntax for Cursors.
2 Answers CarrizalSoft Technologies, HP,
How to execute stored procedure in select statement sql server?
How to read 2nd highest sal from EMP table?
How to genrate automaticlly empid like gt001
What is the language structure to add a record to a table?
Explain about SQL server 2005?
wat is tuff file in log shipping, wt is d use of tht file?
What is enhanced database mirroring in sql server 2008?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)