Solved

SQL Timestamp and VB Type ?

Posted on 2008-10-07
3
312 Views
Last Modified: 2012-05-05
How do I pass a sql Timestamp to a function in VB - what type is the Timestamp?
0
Comment
Question by:Julypobox
  • 2
3 Comments
 
LVL 96

Expert Comment

by:Bob Learned
ID: 22663824
Timestamps vs Datetime data types
http://www.sqlteam.com/article/timestamps-vs-datetime-data-types

<Quote>The SQL Server timestamp data type has nothing to do with times or dates. SQL Server timestamps are binary numbers that indicate the relative sequence in which data modifications took place in a database. The timestamp data type was originally implemented to support the SQL Server recovery algorithms.</Quote>

What are you using the Timestamp data type for?
0
 

Author Comment

by:Julypobox
ID: 22663971
to send to stored procedure to know whether record has been modified... I'm using optimistic locking...  And in the vb code I might pass parameters to another function to do the actual work, like when I'm deleteing I have on sub do the setup/call to sp which reqires the record ID (to know what to delete) and the timestamp. So passing this within my vb code to the sub that does the delete is where I'm stuck.

Private Sub DeleteRow(byval ID as int, byval modified as ??????????)
0
 
LVL 96

Accepted Solution

by:
Bob Learned earned 50 total points
ID: 22663981
Timestamps are binary numbers, which I believe are represented as a byte array.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VB.NET 1 28
vb.net 1 month apart 11 35
VB.net capture  result of a SQL query in variables 3 21
VB.net Adding a row to a DataGridView that has a checkbox column 5 24
Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question