Oracle Converision to SQL2000

  • Is there a system function that compares with Oracle's utl_file function?


    Arthur Lorenzini

  • There is no direct comparison & it depends on what you're trying to do. utl_file allows file I/O from within stored procs, right ?

  • The proc is records records into a table from a textfile.


    Arthur Lorenzini

  • To get text into a table in SqlServer, there are several alternatives:

    - DTS package

    - BULK INSERT command from within a T-SQL batch/procedure

    - bcp command line tool (and calling bcp from xp_cmdshell)

     

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

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