File operations from within stored procedure in SQL 2000

Techie TechTechie Tech Member Posts: 1 ■□□□□□□□□□
Is it possible to perform file operations(read or write) from within stored procedures?


  • 2lazybutsmart2lazybutsmart Member Posts: 1,119
    When using bulk data operations using files, yes. But remember, even then, binary reads/writes aren't possible but rather bulk reads of a character delimited text that is transformed and then inserted into a table.

    Exquisite as a lily, illustrious as a full moon,
    Magnanimous as the ocean, persistent as time.
Sign In or Register to comment.