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 3 of 3   
 

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 | 869 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,256 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,031 reads
   Items 1 to 3 of 3   
 
Tags
cast (1)    
convert (1)    
currency (1)    
datetime (1)    
function (1)    
ip addresses (1)    
ipv4 addresses (1)    
money (1)    
performance tuning (1)    
scalar function (1)    
storage (1)    
t-sql (1)