Solved

SQL Timestamp and VB Type ?

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
LINQ - C# to VB convertion 12 56
VB.Net How to Exit Sub - Exit Form??? 5 57
Put window Form inside tab page 10 33
vb.net help 4 29
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

772 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