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

SQL SERVER – Finding the Occurrence of Character in String

August 16, 2010

This article is written in response to provide hint to TSQL Beginners Challenge 14. The challenge is about counting the number of occurrences of characters in the string. Here is quick method how you can count occurrence of character in any string. Here is quick example which provides you two…

SQL SERVER – Introduction to BINARY_CHECKSUM and Working Example

August 1, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Function, SQL Scripts

In one of the recent consultancy, I was asked if I can give working example of BINARY_CHECKSUM. This is usually used to detect changes in a row. If any row has any value changed, this function can be used to figure out if the values are changed in the rows.…

SQL SERVER – Datetime Function TODATETIMEOFFSET Example

July 16, 2010

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server

Earlier I wrote about SQL SERVER – Datetime Function SWITCHOFFSET Example. After reading this blog post, I got another quick reply that if I can explain the usage of TODATETIMEOFFSET as well.

SQLAuthority News – Converting a Delimited String of Values into Columns

February 10, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL String, SQL XML

This blog post is about two great bloggers and their excellent series of blog posts. It was quite unusual to see two bloggers posting articles that are supporting each other and constantly improving the articles to the next level. Two blogs which I am going to mention here are as…

SQL SERVER – Get Date of All Weekdays or Weekends of the Year

December 29, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

Today’s article is created based on wonderful contribution from Tejas Shah. Tejas is very prominent SQL Expert and .NET wizard. He has answered the query of a reader on this blog who raised the following question: how to generate the date for all the Sundays in the upcoming year. Tejas…

SQL SERVER – Recently Executed T-SQL Query

October 16, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL Function, SQL Scripts, SQL System Table

About a year ago, I wrote blog post about SQL SERVER – 2005 – Last Ran Query – Recently Ran Query. Since, then I have received many question regarding how this is better than fn_get_sql() or DBCC INPUTBUFFER. The Short Answer in is both of them will be deprecated. Please…

SQL SERVER – Insert Values of Stored Procedure in Table – Use Table Valued Function

September 23, 2009

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL Stored Procedure, SQL Table Operation

I recently got many emails requesting to write a simple article. I also got a request to explain different ways to insert the values from a stored procedure into a table. Let us quickly look at the conventional way of doing the same with Table Valued Function.