Blogs about: Sql Function
Featured Blog
SQL SERVER - Recently Executed T-SQL Query
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 INP… more →
Journey to SQL Authority with Pinal Dave
SQL Server - SERVERPROPERTY Function
Bhavesh Patel wrote 2 weeks ago: SERVERPROPERTY Function How does one get list all Server Properties? Well, we can use a very helpful … more →
SQL Server - Set Functions - COUNT, MAX, MIN, SUM and AVG
Bhavesh Patel wrote 3 weeks ago: Set Functions – COUNT, MAX, MIN, SUM and AVG Many times the information we require from table … more →
SQL SERVER - Recently Executed T-SQL Query
pinaldave wrote 1 month ago: About a year ago, I wrote blog post about SQL SERVER – 2005 – Last Ran Query – Recently Ran Query. … more →
SQL Server - Function to split comma delimited String or List
Bhavesh Patel wrote 1 month ago: Function to split a string which is delimited by comma or other delimiter. We often come across a pr … more →
SQL SERVER - Insert Values of Stored Procedure in Table - Use Table Valued Function
— 9 comments
pinaldave wrote 2 months ago: I recently got many emails requesting to write a simple article. I also got a request to explain di … more →
SQL SERVER - Converting Stored Procedure into Table Valued Function
— 6 comments
pinaldave wrote 2 months ago: In one of my recent articles, I mentioned the use of Table Valued Function (TVF) instead of Stored P … more →
SQL SERVER - Connect Item - Vote for Feature Request Function TRIM
— 3 comments
pinaldave wrote 5 months ago: Till date, I have met the SQL Server Product Team twice: first time at SQL Server MVP Meet, Seattle, … more →
SQL SERVER - Difference Between Candidate Keys and Primary Key
pinaldave wrote 5 months ago: Let us first try to grasp the definition of the two keys. Candidate Key – A Candidate Key can … more →
SQL SERVER - Find Hostname and Current Logged In User Name
— 9 comments
pinaldave wrote 6 months ago: I work in an environment wherein I connect to multiple servers across the world. Time and again, my … more →
SQL SERVER - Leading Zero to Number
pinaldave wrote 7 months ago: I have received few emails asking how to prefix any number with zero. I have previously written two … more →
SQL SERVER - Find All Servers From Local Network - Using sqlcmd - Detect Installed SQL Server on Network
— 8 comments
pinaldave wrote 8 months ago: I recently had requirement to create list of all the SQL Server on local network. I remembered that … more →
SQL SERVER - UDF - Pad Ride Side of Number with 0 - Fixed Width Number Display
— 5 comments
pinaldave wrote 8 months ago: I had written article SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number D … more →
SQL SERVER - Pad Ride Side of Number with 0 - Fixed Width Number Display
— 13 comments
pinaldave wrote 8 months ago: Today we will look something which is very quick and but quite frequently useful string operation ov … more →
SQL SERVER - Generate A Single Random Number for Range of Rows of Any Table - Very interesting Question from Reader
— 6 comments
pinaldave wrote 9 months ago: Just a day ago I received email from reader how to get single random number for range of rows of any … more →
SQL SERVER - Remove Duplicate Entry from Comma Delimited String - UDF
— 8 comments
pinaldave wrote 10 months ago: I love reader’s contribution this blog as that brings variety in articles. I encourage my read … more →
SQL SERVER - Find Number of Rows and Disk Space Reserved - Using sp_spaceused Interesting Observation
— 2 comments
pinaldave wrote 10 months ago: Previously I posted SQL SERVER – Find Row Count in Table – Find Largest Table in Databas … more →
SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice - Part 2
— 2 comments
pinaldave wrote 1 year ago: A year ago I wrote post about SQL SERVER – Retrieve – Select Only Date Part From DateTim … more →
SQL SERVER - Get Numeric Value From Alpha Numeric String - UDF for Get Numeric Numbers Only
— 5 comments
pinaldave wrote 1 year ago: SQL is great with String operations. Many times, I use T-SQL to do my string operation. Let us see U … more →
SQL SERVER - 2008 - Enhenced TRIM() Function - Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds
— 8 comments
pinaldave wrote 1 year ago: After reading my article SQL SERVER – 2008 – TRIM() Function – User Defined Functi … more →
