Blogs about: Sql Function
Featured Blog
Simple SQL CSV to Table
Sample Call select @Statecode = ‘IL, IN,KY’ select ColumnData from dbo.fn_CSVToTable(@Statecode) Create Function dbo.fn_CSVToTable (@CSVList Varchar(3000)) Returns @Table Table (ColumnDat… more →
Code Bank
SQL SERVER - Guidelines and Coding Standards Complete List Download
— 3 comments
pinaldave wrote 1 week ago: SQL SERVER - Guidelines and Coding Standards complete List Download Coding standards and guidelines … more →
SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
— 6 comments
pinaldave wrote 2 weeks ago: Download SQL Server 2008 Interview Questions and Answers Complete List Interview is very important e … more →
SQL SERVER - 2008 - Interview Questions and Answers - Part 8
— 1 comment
pinaldave wrote 2 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download What is Data Compression? … more →
SQL SERVER - 2008 - Interview Questions and Answers - Part 6
pinaldave wrote 3 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download 3) Questions of SQL SERVE … more →
SQL SERVER - 2008 - Interview Questions and Answers - Part 4
— 4 comments
pinaldave wrote 3 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download 1) General Questions of S … more →
SQL SERVER - 2008 - Interview Questions and Answers - Part 2
— 8 comments
pinaldave wrote 3 weeks ago: SQL SERVER - 2008 - Interview Questions and Answers Complete List Download 1) General Questions of S … more →
SQL SERVER - Few Useful DateTime Functions to Find Specific Dates
— 9 comments
pinaldave wrote 1 month ago: Recently I have recieved email from Vivek Jamwal, which contains many useful SQL Server Date functio … more →
SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper Case - Part 2
— 1 comment
pinaldave wrote 1 month ago: I had previously written SQL SERVER - UDF - Function to Convert Text String to Title Case - Proper C … more →
SQL SERVER - Get Date Time in Any Format - UDF - User Defined Functions
— 3 comments
pinaldave wrote 1 month ago: One of the reader Nanda of SQLAuthority.com has posted very detailed script of converting any date t … more →
SQL SERVER - Introduction to SERVERPROPERTY and example
— 4 comments
pinaldave wrote 3 months ago: SERVERPROPERTY is very interesting system function. It returns many of the system values. I use it v … more →
SQL SERVER - Create a Comma Delimited List Using SELECT Clause From Table Column
— 7 comments
pinaldave wrote 4 months ago: I received following question in email : How to create a comma delimited list using SELECT clause fr … more →
SQL SERVER - Example of DISTINCT in Aggregate Functions
— 1 comment
pinaldave wrote 4 months ago: Just a day ago, I was was asked this question in one of the teaching session to my team members. One … more →
SQL SERVER - UNPIVOT Table Example
— 1 comment
pinaldave wrote 4 months ago: My previous article SQL SERVER - PIVOT Table Example encouraged few of my readers to ask me question … more →
SQL SERVER - 2005 - Twelve Tips For Optimizing Sql Server 2005 Query Performance
— 11 comments
pinaldave wrote 4 months ago: I recently came across very nice article about optimization tips for SQL Server 2005. Here is the li … more →
SQL SERVER - Function Property - Deterministic or Non-Deterministic
pinaldave wrote 5 months ago: I recently received question through email that how to determine if any user defined function is det … more →
SQL SERVER - Download FAQ Sheet - SQL Server in One Page
— 25 comments
pinaldave wrote 5 months ago: One of the most popular request I have received on this blog is to create one page which list all th … more →
A trivia SQL string function SPACE()
— 1 comment
Emily wrote 6 months ago: Not a really an important function, but SPACE returns a set number of spaces. For example SELECT "HE … more →
SQL SERVER - Find All The User Defined Functions (UDF) - Part 2
pinaldave wrote 7 months ago: Few days ago, I wrote about SQL SERVER - Find All The User Defined Functions (UDF) in a Database. Re … more →
SQL SERVER - UDF to Return a Calendar for Any Date for Any Year
— 8 comments
pinaldave wrote 7 months ago: It gives me great pleasure to write articles like today’s one because I have received great co … more →
Have your say. Start a blog.
See our free features →
An 
Joint
