Post reply

plz cpuld u jus explain to respond o/p in xml

  • January 7, 2008 at 5:33 pm

    #377894

    i have an UI from which we have gateway which is a database from which we have object handlers

    from object handler we have diff methods such as getall,insert,delete,update,set..

    so i get the request in xml so how should i need to respond in xml how can i do that ...

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • January 8, 2008 at 6:08 am

    #765681

    By "respond in XML" do you mean that your output from the query should be in XML?

    If so, look up FOR XML in BOL. That'll get you started.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • January 9, 2008 at 5:15 am

    #766100

    use open xml

    prepare xml string in application and pass it as parameter to sqlproc ,

    using the following builtin proc u can acieve it

    sp_xml_preparedocument,

    OPENXML

    sp_xml_preparedocument,

    u can achieve it

  • January 9, 2008 at 4:44 pm

    #766430

    i jus want it to apply in sql server 2005 n the one u said r for sql 2000

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply