SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, Scalar UDF Rss

   Items 1 to 9 of 9   
 

Why Scalar Functions Can Be Costly

Scalar user defined functions can be costly in more ways than you know. Watch Mickey Stuewe show the hidden costs of using them incorrectly.  Read more...
By Mickey Stuewe 2017/06/02 (first published: 2016/01/04) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,423 reads

Why Scalar Functions Can Be Costly

Scalar user defined functions can be costly in more ways than you know. Watch Mickey Stuewe show the hidden costs of using them incorrectly.  Read more...
By Mickey Stuewe 2017/06/02 (first published: 2016/01/04) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 10,423 reads

The Case for Scalar-valued, User-defined Functions in T-SQL

Did you know that scalar-valued, user-defined functions can be used in DEFAULT/CHECK CONSTRAINTs and computed columns? Learn about it...  Read more...
By Dwain Camps 2015/05/12 | Source: SQLServerCentral.com | Category: scalar udf
Rating: |  Discuss |   Briefcase | 6,239 reads

T-SQL Best Practices - Don't Use Scalar Value Functions in Column List or WHERE Clauses

A classic article by Gerg Larsen explaining how and how not to use a function within your T-SQL statements. Where you place your function within your T-SQL statements determines how your query will be processed and can severely impact the query execution plan and the performance of your query.   Read more...
By Additional Articles 2013/11/28 | Source: Database Journal | Category: t-sql
Rating:  Rate this |   Briefcase | 6,618 reads

How to calculate the check digit for a UCC/EAN code

Function that implements the algorithm for calculating the check digit for a UCC/EAN code  Read more...
By Sergio Govoni 2012/08/29 | Source: SQLServerCentral.com | Category: barcode
Rating: |  Discuss |   Briefcase | 1,874 reads

Payment due date function

Calculates the nth due date for any given date, while accounting for weekends.  Read more...
Rating: |  Discuss |   Briefcase | 2,580 reads

SQL Server Functions: The Basics

SQL Server's functions are a valuable addition to T-SQL when used wisely. Jeremiah Peshcka provides a complete and comprehensive guide to scalar functions and table-valued functions, and shows how and where they are best used.  Read more...
By Additional Articles 2011/11/24 | Source: SimpleTalk | Category: t-sql
Rating: (not yet rated)  Rate this |   Briefcase | 4,034 reads

How to calculate the check digit for a UCC/EAN code

Function that implements the algorithm for calculating the check digit for a UCC/EAN code  Read more...
By Sergio Govoni 2012/08/29 | Source: SQLServerCentral.com | Category: barcode
Rating: |  Discuss |   Briefcase | 1,874 reads

Payment due date function

Calculates the nth due date for any given date, while accounting for weekends.  Read more...
Rating: |  Discuss |   Briefcase | 2,580 reads
   Items 1 to 9 of 9   
 
Tags
barcode (1)    
best practices (1)    
check constraints (1)    
computed columns (1)    
datetime manipulation (1)    
default constraints (1)    
table functions (1)    
ucc/ean (1)    
user defined function (udf) (1)