|
Ispirer SQLWays Database Migration Software
bit, uniqueidentifier and timestamp
bit
Integer data type that can be 1, 0, or NULL.
uniqueidentifier
A globally unique identifier (GUID). A column of uniqueidentifier data type can be initialized using the NEWID function or converting from a string constant in the following form: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx, in which each x is a hexadecimal digit in the range 0-9 or A-F.
timestamp
A database-wide unique number that gets updated every time a row gets updated. The value of a timestamp column is unique within a database. The storage size is 8 bytes.