2012-04-25 (first published: 2012-04-02)
2,212 reads
Denormalize
RE: saving XML stream to a file
You may want to try using an OSQL window to run the SP, then redirect the output to a file. for example: execute('MASTER.DBO.XP_CMDSHELL ''OSQL -U UserName -P ' -|- @PASSWORD -|- ' -Q "EXECUTE DataBase.DBO.SP_Name " -w116 -o' -|- @LOCATIONOFOUTPUTFOLDER -|- '\OutputFilename.TXT''') note -|- is a plus sign, but the forum interface keeps deleting them.
2003-12-05
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers