Home Forums Programming XML adding an xml root attribute RE: adding an xml root attribute

  • October 4, 2007 at 2:22 am

    #738962

    Apologies, I should preview before posting... The REPLACE statement didn't appear correctly and should have been:

    SELECT REPLACE(@xml, '<root>', '<root timestamp="' + CONVERT(VARCHAR(11), GETDATE(), 113) + '">')


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]