Dynamic SQL procedure for bulk insert
https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_BulkUpload.sql
2017-11-17 (first published: 2015-05-16)
3,440 reads
Dynamic sql for convert SQL statement to txt/csv file
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpUnloadSelect.sql
Quick export to flat file.
Before use please enable xp_cmdshell.
2016-12-09 (first published: 2015-05-12)
2,254 reads
Dynamic sql for convert table to flat file using bcp
I comment CATCH section for removing dependence to log procedures.
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpTableUnload.sql
2016-08-22 (first published: 2015-05-07)
1,857 reads
Count character matches with DATALENGTH function
https://github.com/ktaranov/sqlserver-kit/blob/master/Scripts/Count%20character%20matches.sql
2015-06-08 (first published: 2015-05-18)
1,044 reads
2014-04-17 (first published: 2014-03-25)
1,191 reads
Blogs
Arrays in PowerShell–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Passwords = A Good Thing
Those my friends are, in my opinion, one of the single most wonderful things...
Speaking at SQL Saturday Oregon
SQL Saturday Oregon — in the city of Portland — is taking place next...
Forums
Get lat/long from Point
Hello everyone, I have a table with a field "shape" which is geometry. I...
split one rows to multiple rows in the table based on the size
hi there, am new to SQL and now am trying to do row split....
Ask SSC