28,391
社区成员
发帖
与我相关
我的任务
分享sql2000的"timestamp"是什么类型啊,怎么可以查询出来该字段的内容?
直接这样
kk1为字段,类型为:timestamp
kk=rs.fields("kk1").value
response.write kk
输入不出来,怎么可以输出来?
kk1为字段,类型为:timestamp
kk=rs.fields("kk1").value
response.write kk
输入不出来,怎么可以输出来?
...全文
请发表友善的回复…
发表回复
lovehwq21 2003-11-04
- 打赏
- 举报
timestamp
timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.
Remarks
The Transact-SQL timestamp data type is not the same as the timestamp data type defined in the SQL-92 standard. The SQL-92 timestamp data type is equivalent to the Transact-SQL datetime data type.
A future release of Microsoft® SQL Server™ may modify the behavior of the Transact-SQL timestamp data type to align it with the behavior defined in the standard. At that time, the current timestamp data type will be replaced with a rowversion data type.
timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.
Remarks
The Transact-SQL timestamp data type is not the same as the timestamp data type defined in the SQL-92 standard. The SQL-92 timestamp data type is equivalent to the Transact-SQL datetime data type.
A future release of Microsoft® SQL Server™ may modify the behavior of the Transact-SQL timestamp data type to align it with the behavior defined in the standard. At that time, the current timestamp data type will be replaced with a rowversion data type.
