Solved

SQL Timestamp and VB Type ?

Posted on 2008-10-07
3
302 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
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…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

762 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now