Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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  Read more...
By Konstantin Taranov 2015/05/18 | Source: SQLServerCentral.com | Category: string functions
Rating: (not yet rated) |  Discuss |   Briefcase | 61 reads

Dynamic sql procedure for bulk insert

https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_BulkUpload.sql  Read more...
By Konstantin Taranov 2015/05/16 | Source: SQLServerCentral.com
Rating: (not yet rated) |  Discuss |   Briefcase | 165 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 | 1,190 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 2015/05/21 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,031 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,081 reads
   Items 1 to 5 of 5