Post reply

Retrive rows using field number or column number

  • February 7, 2006 at 4:55 am

    #170881

     Hi all,

    Could anyone please let me know how can I retrive data in select statement in which the where clause will have the field number or column number rather than field name?

    If you have any queries let me know.

    Thanks in advance,

    Vinoth

  • February 7, 2006 at 5:56 am

    #619218

    I'v never scene this done.  I know you can use a column number that corelates to the filed order defined in your SELECT statement in the ORDER BY clause but I am unaware of any way to do this in the WHERE clause.

  • February 7, 2006 at 6:14 am

    #619223

    I agree ramses2nd!

    The real problem is..

    I have 2 CSV files say ordermaster.csv and orderdetails.csv which will be generated from an application. What I need to do is, read these 2 files and save the ordermaster and order detail data into the database table..any idea to achieve this?

  • February 8, 2006 at 12:34 pm

    #619615

    For SQL-Server 2000 I would use dts or bcp (bulk copy) to load the data from the csv file into a table in the database.  You can then process the table after it has been loaded.

    Steve

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

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