Information générale
Forum:
Microsoft SQL Server
>Does anyone know if SQL Server can be programmed to create a text file from within a trigger or stored procedure. I searched BOL (ineptly probably) but a SQL equivalent to VFP's STRTOFILE() just didn't exist ;-) ...
>
>Thanks in advance,
>
>CT
Generally you would use DTS or Bulk Copy. I think you can start them both from an SP using xp_cmdshell.
I generally prefer doing exports from VFP. I have an SP that returns the data I need, and then COPY TO from VFP or I scan the table and build the layout I need.
BOb
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement