varchar最大长度是8000,不定长,nvarchar支持uucode,timestamp是时间戳
nvarchar(n)
variable-length unicode character data of n characters, n must be a value
from 1 through 4000. storage size, in bytes, is two times the number of
characters entered. the data entered can be 0 characters in length. the sql-92
synonyms for nvarchar are national char varying and national character
varying.
timestamp: A database-wide unique number, the storage size is 8 bytes.
a table can have only one timestamp column. the value in the timestamp column
is updated every time a row containing a timestamp column is inserted or
updated. This property makes a timestamp column a poor candidate for keys,
especially primary keys, any update made to the row changes the timestamp
value,thereby changing the key value, if the column is in a primary key,
the old key value is no longer valid, and foreign keys referencing the old
value are no longer valid. if the table is referenced in a dynamic cursor,
all updates change the position of the rows in the cursor, if the column is
in an index key, all updates to the data row also generate updates of the
index.
the value of a timestamp column is unique within a database.
a nonnullable timestamp column is semantically equivalent to a binary(8)
column, a nullable timestamp column is semantically equvalent to a varbinary(8) column.
nvarchar(n)
variable-length unicode character data of n characters, n must be a value
from 1 through 4000. storage size, in bytes, is two times the number of
characters entered. the data entered can be 0 characters in length. the sql-92
synonyms for nvarchar are national char varying and national character
varying.
timestamp: A database-wide unique number, the storage size is 8 bytes.
a table can have only one timestamp column. the value in the timestamp column
is updated every time a row containing a timestamp column is inserted or
updated. This property makes a timestamp column a poor candidate for keys,
especially primary keys, any update made to the row changes the timestamp
value,thereby changing the key value, if the column is in a primary key,
the old key value is no longer valid, and foreign keys referencing the old
value are no longer valid. if the table is referenced in a dynamic cursor,
all updates change the position of the rows in the cursor, if the column is
in an index key, all updates to the data row also generate updates of the
index.
the value of a timestamp column is unique within a database.
a nonnullable timestamp column is semantically equivalent to a binary(8)
column, a nullable timestamp column is semantically equvalent to a varbinary(8) column.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货