Re: How to get SQL timestamp value using VB.NET

Tech-Archive recommends: Speed Up your PC by fixing your registry

----------------
AccessFlagLookup
----------------

SELECT AccessFlagLookupID, AccessFlag, Description, LastUpdated,
LastUpdatedBy, CAST(TS AS INT) AS TS FROM AgencyNET.AccessFlagLookup

INSERT INTO [AgencyNET].[AccessFlagLookup] ([AccessFlag], [Description],
[LastUpdatedBy]) VALUES (@AccessFlag, @Description, @LastUpdatedBy);SELECT
AccessFlagLookupID, CAST(TS AS INT) AS TS FROM AgencyNET.AccessFlagLookup
WHERE (AccessFlagLookupID = SCOPE_IDENTITY())

UPDATE [AgencyNET].[AccessFlagLookup] SET [AccessFlag] = @AccessFlag,
[Description] = @Description, [LastUpdated] = getutcdate(), [LastUpdatedBy]
= @LastUpdatedBy WHERE (([AccessFlagLookupID] =
@Original_AccessFlagLookupID) AND (CAST(TS AS INT) = @Original_TS));SELECT
CAST(TS AS INT) AS TS FROM AgencyNET.AccessFlagLookup WHERE
(AccessFlagLookupID = @AccessFlagLookupID)

DELETE FROM [AgencyNET].[AccessFlagLookup] WHERE (([AccessFlagLookupID] =
@Original_AccessFlagLookupID) AND (CAST(TS AS INT) = @Original_TS))

-
"M Lee" <M Lee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:956C6D14-9FEB-4E19-A272-54B67E6D8D5D@xxxxxxxxxxxxxxxx
How do you get the actual value of a timestamp from a SQL Server 2000
database table using VB.Net? My recordset is returning a "System.Byte[]"
Type. How can I convert it into something usable?


.