SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Konstantin Taranov

SQLServerCentral.com profile

   Items 1 to 5 of 5   

Count character matches with DATALENGTH function

https://github.com/ktaranov/sqlserver-kit/blob/master/Scripts/Count%20character%20matches.sql 
By Konstantin Taranov 2015/06/08 | Source: SQLServerCentral.com | Category: string functions
Rating: (not yet rated) |  Discuss |   Briefcase | 1,040 reads

Dynamic SQL procedure for bulk insert

https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_BulkUpload.sql 
By Konstantin Taranov 2017/11/17 | Source: SQLServerCentral.com | Category: bulk insert
Rating: |  Discuss |   Briefcase | 3,346 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.  Read more...
Rating: |  Discuss |   Briefcase | 2,217 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  Read more...
By Konstantin Taranov 2016/08/22 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,816 reads

Dynamic table unpivot

Generate and execute dynamically select statement for unpivot table  Read more...
By Konstantin Taranov 2014/04/17 | Source: SQLServerCentral.com | Category: unpivot
Rating: |  Discuss |   Briefcase | 1,169 reads
   Items 1 to 5 of 5