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

Content with tag format Rss

   Items 1 to 5 of 5   
 

Format decimal value to fraction using a tally table.

We use a tally table to find the appropriate denominator for a given decimal part of a number.   Read more...
By Adrian Facio 2014/04/29 | Source: SQLServerCentral.com | Category: format
Rating: |  Discuss |   Briefcase | 865 reads

Function to format a datetime variable by a mask

I have used the following function to convert dates according to desired textual formats that were not immediately available in the standard styles on offer.  Read more...
By Colin Frame 2013/10/18 | Source: SQLServerCentral.com | Category: datetime
Rating: |  Discuss |   Briefcase | 1,535 reads

Date Format

Returns your date in the format mask you require.  Read more...
By Ervin Santiago 2013/03/11 | Source: SQLServerCentral.com | Category: date
Rating: |  Discuss |   Briefcase | 1,858 reads

Generate Column Metadata

This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.  Read more...
By Steven Willis 2013/02/12 | Source: SQLServerCentral.com | Category: utility
Rating: |  Discuss |   Briefcase | 585 reads

Performance Test of New Date Manipulation Functions (SQL Spackle)

Performance test of new SQL 2012 functions DateTimeFromParts and Format  Read more...
By Wayne Sheffield 2012/05/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 5,888 reads
   Items 1 to 5 of 5   
 
Tags
date (2)    
datetime (1)    
datetimefromparts (1)    
decimal (1)    
fraction (1)    
function (1)    
information_schema (1)    
mask (1)    
performance tuning (1)    
sql server 2012 (1)    
utility (1)