which data type responding to DBTYPE_DBTIMESTAMP?
-
Hi there, My VC codes access SQL Server via ADO (using help class CADORecordBinding). I have a DBTYPE_DBTIMESTAMP data type column. How can I put value in it? Is there a data type responding to it in C++? X|
-
Hi there, My VC codes access SQL Server via ADO (using help class CADORecordBinding). I have a DBTYPE_DBTIMESTAMP data type column. How can I put value in it? Is there a data type responding to it in C++? X|
Out of SQL Server Books Online: 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. ... A nonnullable timestamp column is semantically equivalent to a binary(8) column. A nullable timestamp column is semantically equivalent to a varbinary(8) column. So it does not look like you can set a value to it. It is auto generated by the server...
-
Out of SQL Server Books Online: 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. ... A nonnullable timestamp column is semantically equivalent to a binary(8) column. A nullable timestamp column is semantically equivalent to a varbinary(8) column. So it does not look like you can set a value to it. It is auto generated by the server...
Maybe my words were not clear enough, I find the corresponding data type in C++ not anything else. And more, I've found it in 'ADO Data Bound Class Wizard' article. Thanks for ur help! Best regard, Kamp Huang:rose: