Groups > comp.databases.ms-sqlserver > #843

Re: more about timestamp

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: more about timestamp
Date	Thu, 24 Nov 2011 23:44:31 +0100
Organization	Erland Sommarskog
Lines	38
Message-ID	<Xns9FA7F18408B66Yazorman@127.0.0.1> (permalink)
References	<4ece237f$0$284$14726298@news.sunsite.dk>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx04.eternal-september.org; posting-host="nBFDv6s1VJQDuF1w6hpX2A"; logging-data="1127"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18VUtBoWJFUUHOIcPw79gN4"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:ZCpm1l+Ygl2LeAahZEFw3YOtUsM=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:843

Show key headers only | View raw

Tony (johansson.andersson@telia.com) writes:
> One strange thing when I add a timestamp column to a table and then
> changed some rows and then made a select in the Server explorer that
> exist in VS I didn't see any values in this timestamp column. It showed
> only this 
><Binary> in the timestamp column. 
> But if I instead used the same select from within SQL Server Management 
> studio I can see values like 0x0000000000001F43
> Can somebody why a select on the timestamp give different result beween 
> Server explorer and SQL Server Management studio

For some reason Visual Studio prefers to censor your data. You will 
have to ask the VS people about why. Just remember: what you see in a 
GUI is just a visuall representation.

> So how do I define the timestamp parameter RowTimestamp to get rid of this 
> error ?

With the .AddParameters method on the SqlCommand object. Exactly 
how you do that in ASP .Net I don't know, since I don't know ASP .Net.
You will need to ask in a ASP .Net forum.

But so much is clear:

> The first parameter ProductID is fetched from the DropDownList control 
> ddlProducts so that was easy.

In the long run you cannot write applications only by pointing and 
clicking in GUIs. That will only take you so far.

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar

Thread

more about timestamp "Tony" <johansson.andersson@telia.com> - 2011-11-24 11:19 +0100
  Re: more about timestamp Erland Sommarskog <esquel@sommarskog.se> - 2011-11-24 23:44 +0100

csiph-web