Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SUBSTRING Rss

   Items 1 to 4 of 4   
 

Split String Function

This In-line Table Valued Function returns a table with individual records parsed from a string.  Read more...
By Chris Kutsch 2015/04/16 | Source: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 2,117 reads

Format Currency Into a String

I had a requirement to produce a formatted currency string from within SQL server. I was able to build this scalar-valued function to meet the requirement.  Read more...
By Chris Kutsch 2013/05/13 | Source: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 910 reads

Storing IPv4 Addresses for Performance

An in-depth analysis on how to store IPv4 addresses to achieve maximum efficiency and performance in both storage and queries  Read more...
By Jean-Sebastien Carle 2009/08/19 | Source: SQLServerCentral.com | Category: ipv4 addresses
Rating: |  Discuss |   Briefcase | 8,287 reads

GetDateTime Function

This function gets a variable string and converts to DateTime format 'YYYY-MM-DD HH:MM' Ex. '200907111405' Convert to '2009-07-11 14:05:00'   Read more...
By Luis Atondo 2009/07/30 | Source: SQLServerCentral.com | Category: convert
Rating: |  Discuss |   Briefcase | 1,053 reads
   Items 1 to 4 of 4   
 
Tags
cast (1)    
convert (1)    
currency (1)    
datetime (1)    
function (1)    
ip addresses (1)    
ipv4 addresses (1)    
money (1)    
parse string (1)    
performance tuning (1)    
recursion (1)    
scalar udf (1)    
storage (1)    
t-sql (1)