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 - 2004-01-13 : 08:01:25
|
| Ziyad Saleh writes "Hi , I am working on a project that uses SQL server 2000 ( SP3 ) XML functionality , with intensive use of the command OpenXML inside my Stored procs. but I am facing a problem when trying to read fields with text datatype ( actually I need this datatype and can not change it to varchar )from XML passed string to the stored procesure , but things are not working properly, the text field is not updated unless it is changed to varchar ,the amazing thing is that this does not appear in a similar insert statement , only in update ? Is there a solution for this ? Note , I use something like :UPDATE EmploymentSET Employment_Category_ID = XML_Search.Employment_Category_ID, Publish_FL= XML_Search.Publish_FL , Job_Title = XML_Search.Job_Title, Short_Intro= XML_Search.Short_Intro, Publish_Date= XML_Search.Publish_Date, Full_Job_Description= XML_Search.Full_Job_Description, Other_Attributes= XML_Search.Other_Attributes, Upd_By = XML_Search.Upd_ByFROM Employment INNER JOIN ( SELECT * FROM OpenXML(@IDoc, '//Job_Title/..',2) WITH ( Employment_Category_ID Int, Publish_FL Bit, Job_Title Varchar(255), Short_Intro Varchar(150), Publish_Date DateTime, Full_Job_Description Text, Other_Attributes Text, Upd_By Int ) )XML_Search ON Employment.Employment_ID = @Employment_ID" |
|
|
|
|
|
|
|
problems with text datatype in OpenXML