Home Forums SQL Server 7,2000 T-SQL How to write query result in an output file in T-SQL (MSDE) RE: How to write query result in an output file in T-SQL (MSDE)

  • November 22, 2007 at 1:40 am

    #753319

    Thanks Ahmed,

    The 1st method with xp_cmdshell cannot be used because of security method.

    With the second one (with execute @OLEResult = sp_OAMethod @FileID ,'WriteLine', Null, @STR)

    I don't arrive to return the entirely result of the select * in one line in an output file.

    Maybee there is an other method than WriteLine or Write to return easily the result of a select *...