-
call bcp from stored procedure
Hi
How can I call the bcp from Stored procedure and generate text file ?
thank you in advance
-
call bcp from stored procedure (reply)
Hi
You can run the bcp command through ESP xp_cmdshell.
For example, inside your stored proc, add the following sql command
exec xp_cmdshell 'bcp dbname..table out filename.bcp .....'
cheers
Joe
------------
mutley at 5/22/2002 11:50:20 AM
Hi
How can I call the bcp from Stored procedure and generate text file ?
thank you in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|