Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-06-10 : 08:33:14
|
| Manoj writes "Hi,I am getting xml using .GetXML() method of dataset in .net and passing it to storedproc where i am using openxml to insert/update the records. The problem i am facing is that boolean/bit columns gets converted to false value and when i use openxml with it i get error "Syntax error converting the varchar value to a column of data type bit." Thus not sure what to do.ThanksManoj Rastogi" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-10 : 12:59:59
|
| Why don't you just convert the data to what is needed for your stored procedure? If you get "False", then change it to 0.Tara |
 |
|
|
|
|
|
Data Conversion using .GetXML()