Yes i find a way to update my fields with openxml in store proc in sql but
Is there a way to avoid having null value to my update command...
I got an xml in paramaters of my store proc and then update just the columns that i have in my string.. but when i do update it updates all of them.. and the field that i dont have in my xml well. they get a null value.. but i want to keep the correcte one in the column in the table !!
EXEC sp_xml_preparedocument @handle OUTPUT, @data
SELECT * FROM TblTypeSalle WHERE IdTypeSalle = 153