Is there a command in SSMS to write a resultant set to a local file?
something like select 'my text' output to 'c:\test\mytext.txt'
I can not use the resultant set to "save the result into a file option". Because I have some more script to follow once I saved the results to a file.
TIA
something like select 'my text' output to 'c:\test\mytext.txt'
I can not use the resultant set to "save the result into a file option". Because I have some more script to follow once I saved the results to a file.
TIA