Export SQL to Text

Oddly I heard this question today.  It has been awhile but thought I would note for others for future reference the bcp command:For a comma separated file: From your sql server management studio run the below: declare @sql varchar(8000) SELECT @sql = ‘bcp “select * from [dbname]..[table name]” queryout c:\temp\mytest.txt -c -t, -T -S [server name]‘ exec master..xp_cmdshell @sql

Posted by on November 7, 2011

Hot Toddy Time

So it’s that time of year again where we have the sniffles, or just want to settle down to a nice, comfortable, relaxing evening with a warm tasty drink in hand. This brings to mind a nice Hot Toddy. There are many ways to make this and really it’s up to your taste but, if […]

Posted by on November 7, 2011

ChatClick here to chat!+