Options

File operations from within stored procedure in SQL 2000

Techie TechTechie Tech Member Posts: 1 ■□□□□□□□□□
in General Certification
Is it possible to perform file operations(read or write) from within stored procedures?
· Share on FacebookShare on Twitter

Comments

  • Options
    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.

    2lbs.
    Exquisite as a lily, illustrious as a full moon,
    Magnanimous as the ocean, persistent as time.
    · Share on FacebookShare on Twitter
Sign In or Register to comment.