SQL Server with Mr. Denny:

Functions

1

February 8, 2010  11:00 AM

Using XMLNAMESPACES within a function



Posted by: Denny Cherry
Functions, T/SQL, XML

Recently one of my developers asked me to begin returning data from a function as XML instead of a comma separated list.  My thoughts on this was awesome, another cursor getting removed from the system.  I'll write a quick FOR XML AUTO, ROOT('root') at the bottom of the SELECT statement being...

April 11, 2008  5:00 AM

Back To Basics: Functions, the good and the bad



Posted by: Denny Cherry
Back To Basics, Functions, SQL

Functions are create little blocks of code.  They are fantastic for converting data from one format to another, or for looking up other values based on a lookup.  However this comes at a price.  That price is CPU power.  Doing all these additional lookups can cause extra strain on the database...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: