Post reply

Data import

  • November 4, 2011 at 12:30 am

    #390763

    Hi to all,

    I have 120GB database,i have to import data from my DB to XML file by date ,but my problem is i dont know my DB tables structure whether column like datetime or timestamp are available or not in tables if column available then there is no proble for me if that cand of columns are not available in tables then what i have to do i am not understanding. So please could any one help me with this.

    Thanks

  • November 4, 2011 at 8:55 pm

    #1403573

    Are you saying that you want to give, say, a stored procedure just a table name and have the stored procedure generate the XML for the data in the entire table?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 2 posts - 1 through 1 (of 1 total)

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