Define Identity and uniqueidentifier property of Column?
Submitted by: AdministratorIdentity Column
► Column with identity property contains unique system generated value in the table.
► Column with identity property is similar to AutoNumber field in MS Access.
► You can set start and increment value while setting column property to identity.
► Column with identity property contains unique values within the table.
Uniqueidentifier, GUID
► The column with uniqueidentifier property contains globally unique data.
► SQL server uses uniqueidentifier property for merge replication.
► Same like Identity Column, SQL server supports uniqueidentifier column that also contains system generated value.
► A column or local variable of uniqueidentifier data type can be initialized using NEWID function.
Submitted by: Administrator
► Column with identity property contains unique system generated value in the table.
► Column with identity property is similar to AutoNumber field in MS Access.
► You can set start and increment value while setting column property to identity.
► Column with identity property contains unique values within the table.
Uniqueidentifier, GUID
► The column with uniqueidentifier property contains globally unique data.
► SQL server uses uniqueidentifier property for merge replication.
► Same like Identity Column, SQL server supports uniqueidentifier column that also contains system generated value.
► A column or local variable of uniqueidentifier data type can be initialized using NEWID function.
Submitted by: Administrator
Read Online SSRS Job Interview Questions And Answers
Top SSRS Questions
☺ | Explain the architecture of reporting services? |
☺ | What is RAID (Redundant Array of Inexpensive disks)? Explain its level? |
☺ | What are the ways to tune Reporting Services? |
☺ | Describe Reporting Lifecycle? |
☺ | What can SQL Server Reporting Services do? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |