tags:

views:

41

answers:

1
+1  Q: 

set string to sqlbinary

Hi,

I'm having issues with setting a string to sqlbinary or something like that.

Example:

The string comes from a csv file: 0x0000000001E5CFE7 It's read into string, but now I have to execute a stored procedure with the parameter timestamp, because it's an timestamp.

Does anyone have an idea for me how to set this.

+1  A: 

You can't set a timestamp in SQL Server - it is DB generated and only written to by SQL Server itself. Although it is semantically equivalent to a binary(8), you can't explicitly set the value, only read it.

You can compare a timestamp value directly to a variable or literal of type binary(8) however if that's what you're trying to do.

David M  2009-07-13 13:45:12
It's not used to set the timestamp, but for validation if the row is not changed after data manipulation.So that isn't a problem.
MysticSlayer  2009-07-13 13:54:17
Have edited post
David M  2009-07-13 13:59:47

related questions

Does anyone have a good Proper Case algorithm
Converting bool to text in C++
Does PHP have an equivalent to this type of Python string substitution?
PHP ToString() equivalent
What's the difference between a string constant and a string literal?
What would be the fastest way to remove Newlines from a String in C#?
Why is String.Format static?
PowerShell - How do I pass string parameters correctly?
What's the best string concatenation method using C#?
Java: Best way of converting List<Integer> to List<String>
C# String output: format or concat?
Parse usable Street Address, City, State, Zip from a string
C# Save Dialogs
How do I Convert a string to an enum in C#?
PowerShell - how do I do a string replacement in a function?
Case insensitive string comparison in C++
Why doesn't Ruby have a real StringBuffer or StringIO?
Checking for string contents? string Length Vs Empty String
Remove Quotes and Commas from a String in MySQL
Test serialization encoding
In C# what is the difference between String and string
String.indexOf function in C
What is the best way to parse strings in Java
Format string to title case
Generate list of all possible permutations of a string