• 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.