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

Content with tag UDF Rss

   Items 1 to 17 of 17   
 

Rendering PDFs Natively in SQL

How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.  Read more...
By David Rueter 2013/05/08 | Source: SQLServerCentral.com | Category: pdf
Rating: |  Discuss |   Briefcase | 15,559 reads

Deploying CLR Assemblies with T-SQL

Learn how to simplify deployment and maintenance of SQL CLR assemblies by using T-SQL instead of Visual Studio.  Read more...
By David Rueter 2013/05/07 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 5,747 reads

Find all actual words from Dictionary Table using jumbled word

How to get all actual word from a table,if I pass a jumbled word  Read more...
By Ajeet Singh 2012/09/27 | Source: SQLServerCentral.com | Category: cross apply
Rating: |  Discuss |   Briefcase | 768 reads

SQL Code Reuse: Teaching a Dog New Tricks

Developers, by every natural instinct and training, strive to make their code reusable and generic. Dissuading them from doing so, in certain circumstances, is akin to trying to persuade a dog not to fetch a stick.  Read more...
By Additional Articles 2011/09/26 | Source: SimpleTalk | Category: code reuse
Rating:  Rate this |   Briefcase | 3,325 reads

How to use temporary table in function

See a short and dirty example how to use temporary table in user defined function (UDF).  Read more...
By Jakub Dvorak 2011/07/21 | Source: SQLServerCentral.com | Category: udf
Rating: |  Discuss |   Briefcase | 8,644 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,896 reads

Get Item from Delimited List at Position

Returns the item from a delimited list at the specified position. Both position and delimiter are parameters.  Read more...
By Chad Casady 2011/03/10 | Source: SQLServerCentral.com | Category: udf
Rating: |  Discuss |   Briefcase | 1,022 reads

Prepend Value to Delimited List

Takes a delimited list and prepends a value to the beginning.  Read more...
By Chad Casady 2011/03/09 | Source: SQLServerCentral.com | Category: udf
Rating: |  Discuss |   Briefcase | 770 reads

List Count

Counts the number of items in a delimited list.  Read more...
By Chad Casady 2011/03/07 | Source: SQLServerCentral.com | Category: udf
Rating: |  Discuss |   Briefcase | 8,574 reads

Append Value to Delimited List

Takes a delimited list and appends a value to the end.  Read more...
By Chad Casady 2011/03/04 | Source: SQLServerCentral.com | Category: udf
Rating: |  Discuss |   Briefcase | 6,073 reads

Creating User-Defined Functions in Microsoft SQL Server

SQL Server's own list of functions is limited as far as what is available for database developers to use in their applications. Starting with SQL Server 2000, database developers were given the ability to create their own routines that accept parameters, perform custom actions and return results.  Read more...
By Additional Articles 2010/09/28 | Source: Database Journal | Category: udf
Rating:  Rate this |   Briefcase | 4,014 reads

Fun with business days, calendar tables, and test-driven development

We shall discuss how to build a calendar table, and use it in calculations involving business days  Read more...
By Alex Kuznetsov 2010/09/23 | Source: SQLServerCentral.com | Category: test-driven development
Rating: |  Discuss |   Briefcase | 7,102 reads

4-4-5 Calendar Functions, Part 1

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.  Read more...
By Cliff Corder 2010/09/06 (first published: 2009/09/28) | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 19,388 reads

fn_getfiledetails - a replacement for xp_getfiledetails

As the undocumented SQL Server 2000 function xp_getfiledetails is not existent any more in 2005 or later i needed a replacement...  Read more...
By Karl Klingler 2010/06/14 | Source: SQLServerCentral.com | Category: xp_getfiledetails
Rating: |  Discuss |   Briefcase | 1,682 reads

4-4-5 Calendar Functions, Part 2

Part 2 showing how to get the Period in a 4-4-5 Calendar  Read more...
By Cliff Corder 2010/01/11 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 8,628 reads

Synchronize a function between two servers

It's the same with spSynchStoredProcedure  Read more...
By Th Tr 2009/12/23 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 556 reads

4-4-5 Calendar Functions, Part 1

New author Cliff Corder has a SQL Server function to report on a 4-4-5 Calendar Accounting Year.  Read more...
By Cliff Corder 2010/09/06 (first published: 2009/09/28) | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |   Briefcase | 19,388 reads
   Items 1 to 17 of 17   
 
Tags
t-sql (7)    
4-4-5 accounting (2)    
assembly (2)    
fiscal year (2)    
function (2)    
sqlclr (2)    
string manipulation (2)    
.net (1)    
blogs (1)    
code reuse (1)    
cross apply (1)    
defensive programming (1)    
formatting (1)    
pdf (1)    
render (1)    
sql server (1)    
stream (1)    
temporary tables (1)    
test-driven development (1)    
t-sql tuesday (1)    
user defined function (1)    
user defined functions (1)    
validate email (1)    
validate ssn (1)    
validate url (1)    
validation functions (1)    
xp_getfiledetails (1)