TIMESTAMP parameter: SqlDbType.Timestamp or SqlDbType.VarBinary?

  • Thread starter Thread starter TR
  • Start date Start date
T

TR

When using VB.Net, what type do you choose for a TIMESTAMP parameter?

SqlDbType.Timestamp

OR

SqlDbType.VarBinary


And what size do you enter? 8?


Regards
TR
 
If you are using a MS SQL Server timestamp for concurrency conflict
checking, cast the timestamp as an int.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting timestamp parameter 1
Conversion of .NET DateTime to SQL datetime via VarBinary 1
Using a Timestamp field to implement optimistic concurrency 2
Unable to save byte[] to database 8
How to get SQL timestamp value using VB.NET 4
Optimistic Concurrency and TimeStamp 4
Dataset timestamp fails to update 1
Timestamp Datatype issues 6

Back
Top