SQL Function Archives - Page 52 of 52 - SQL Authority with Pinal Dave

SQL SERVER – Creating Comma Separate List From Table

February 20, 2007

SQL Function, SQL Scripts, SQL Stored Procedure, SQL String

Update : (5/5/2007) I have updated the script to support SQL SERVER 2005. Visit :SQL SERVER – Creating Comma Separate Values List from Table – UDF – SP Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – Function to Convert List to Table

February 10, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

Update : (5/5/2007) I have updated the UDF to support SQL SERVER 2005. Visit :SQL SERVER – UDF – Function to Convert List to Table Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – UDF – Function to Convert Text String to Title Case – Proper Case

February 1, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

Following function will convert any string to Title Case. I have this function for long time. I do not remember that if I wrote it myself or I modified from original source. Run Following T-SQL statement in query analyzer: SELECT dbo.udf_TitleCase('This function will convert this string to title case!') The…