creating file (urgent)

hi,
I am trying to create a file using a query in SQL...
kindly help.
Thankyou. -- VijayUse OSQL utility to create a file, refer to books online for more information.|||master..xp_cmdshell 'bcp table out filename...'

Look it up in Books Online...|||Using BCP you can export full data from a table, but in case of OSQL you can use a query or set of statements(SP) to output the result.|||Originally posted by Satya
Using BCP you can export full data from a table, but in case of OSQL you can use a query or set of statements(SP) to output the result.

Que' pasta?

QUERYOUT

CREATE VIEW...|||xp_cmdshell 'echo Hello >> c:\Enigma.txt'|||thanxs for the help...it really helped me...I really am very lucky to have found this site and I recommends all my friends join in and do their bit in helping each other out and sharing info. Thankyou again.
-- Vijay.|||Uh-oh, my manager just told me...that my job is being outsourced...to an Indian contractor... Is it you, vijayk?|||Well forums are meant for helping... :)
Originally posted by vijayk
thanxs for the help...it really helped me...I really am very lucky to have found this site and I recommends all my friends join in and do their bit in helping each other out and sharing info. Thankyou again.
-- Vijay.