Viewing 4 posts - 106 through 109 (of 109 total)
imarran (5/21/2015)
Some nice code and a useful tool 🙂Will need to replace the "THROW" command with RAISERROR to make it work on older versions of SQL Server
Thanks for your comment....
May 21, 2015 at 2:42 am
pawel.sowka (5/21/2015)
SET @cmdCommand = 'del ' + @filePath;Why output file is deleted?
Hello pawel.sowka, thanks for your question.
Output file deleted only if parameter @outputColumnHeaders = 1 (see below if expression) because...
May 21, 2015 at 2:35 am
Hello.
For own needs I use similar script: https://github.com/ktaranov/sqlserver-kit/blob/master/Strored%20Procedure/usp_bcpTableUnload.sql
Comment Execute statements in catch block or install error log and print procedure:
https://github.com/ktaranov/sqlserver-kit/blob/master/Strored%20Procedure/usp_PrintError.sql
https://github.com/ktaranov/sqlserver-kit/blob/master/Strored%20Procedure/usp_LogError.sql
May 6, 2015 at 6:22 am
Hello. I found misprint in this row:
WHEN 110 THEN 'SQL Server 2011'
SQL Server 2011 change on 2012
March 14, 2014 at 6:20 am
Viewing 4 posts - 106 through 109 (of 109 total)