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

Content with tag formatting Rss

   Items 1 to 9 of 9   
 

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: formatting
Rating: |  Discuss |   Briefcase | 893 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,563 reads

Formatting Dates with 3 Character Months (SQL Spackle)

Another in the series of articles to help you "fill in the cracks" in your T-SQL knowledge. MVP Jeff Moden shows us a super simple, high performance method to solve this timeless problem.  Read more...
By Jeff Moden 2013/07/19 (first published: 2011/01/20) | Source: SQLServerCentral.com | Category: formatting
Rating: |  Discuss |   Briefcase | 17,959 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,875 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 | 600 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,898 reads

SQL Validation Functions - 4 Cool UDF's to have handy

Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...  Read more...
By Robert Pearl 2011/04/07 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 8,897 reads

Formatting Dates with 3 Character Months (SQL Spackle)

Another in the series of articles to help you "fill in the cracks" in your T-SQL knowledge. MVP Jeff Moden shows us a super simple, high performance method to solve this timeless problem.  Read more...
By Jeff Moden 2013/07/19 (first published: 2011/01/20) | Source: SQLServerCentral.com | Category: formatting
Rating: |  Discuss |   Briefcase | 17,959 reads

Display Rows Vertically or Alphabetically

Display a row vertically when a table has hundreds of columns to avoid scrolling.  Read more...
By William Talada 2010/01/21 | Source: SQLServerCentral.com | Category: select
Rating: |  Discuss |   Briefcase | 2,735 reads
   Items 1 to 9 of 9   
 
Tags
date (2)    
blogs (1)    
date manipulation (1)    
datetime (1)    
datetimefromparts (1)    
decimal (1)    
fraction (1)    
function (1)    
information_schema (1)    
mask (1)    
performance tuning (1)    
select (1)    
sql server 2012 (1)    
sql spackle (1)    
t-sql tuesday (1)    
udf (1)    
user defined functions (1)    
utility (1)    
validate email (1)    
validate ssn (1)    
validate url (1)    
validation functions (1)    
views (1)