using the article example.
this is empty xml (assuming it's the content of the file is coming from outside, meaning the content was read in an .xml file
DECLARE @emp AS XML(EmployeeSchema)
SET @emp = ''
this is empty xml (assuming it's the content of the file is coming from outside, meaning the content was read in an .xml file
DECLARE @emp AS XML(EmployeeSchema)
SET @emp = 'put a valid xml comment here'
why to two last statement is valid??? why an empty xml or an xml with valid xml comment cannot be validated by predefined schema.
is there a way to validated an empty xml or an xml file which is the only content is a valid xml comments?
please help.