Blogs about: Sql Function

Featured Blog

SQL SERVER - 2005 - 2008 - Delete Duplicate Rows

I had previously penned down two popular snippets regarding deleting duplicate rows and counting duplicate rows. Today, we will examine another very quick code snippet where we will delete duplicate r… more →

Journey to SQL Authority with Pinal Dave

SQL SERVER - Connect Item - Vote for Feature Request Function TRIM — 3 comments

pinaldave wrote 1 month ago: Till date, I have met the SQL Server Product Team twice: first time at SQL Server MVP Meet, Seattle, … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, SQL Authority, Pinal Dave, T-SQL, Microsoft Connect

SQL SERVER - Difference Between Candidate Keys and Primary Key

pinaldave wrote 1 month ago: Let us first try to grasp the definition of the two keys. Candidate Key – A Candidate Key can … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Constraint and Keys, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - Find Hostname and Current Logged In User Name — 4 comments

pinaldave wrote 1 month ago: I work in an environment wherein I connect to multiple servers across the world. Time and again, my … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - Leading Zero to Number

pinaldave wrote 2 months ago: I have received few emails asking how to prefix any number with zero. I have previously written two … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, SQL Authority, Pinal Dave, T-SQL, SQL Scripts

SQL SERVER - Find All Servers From Local Network - Using sqlcmd - Detect Installed SQL Server on Network — 8 comments

pinaldave wrote 3 months ago: I recently had requirement to create list of all the SQL Server on local network. I remembered that … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, sqlcmd, T-SQL

SQL SERVER - UDF - Pad Ride Side of Number with 0 - Fixed Width Number Display — 5 comments

pinaldave wrote 3 months ago: I had written article SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number D … more →

Tags: Best Practices, Pinal Dave, reader's contribution, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks

SQL SERVER - Pad Ride Side of Number with 0 - Fixed Width Number Display — 11 comments

pinaldave wrote 3 months ago: Today we will look something which is very quick and but quite frequently useful string operation ov … more →

Tags: Best Practices, Pinal Dave, Reader's question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks

SQL SERVER - Generate A Single Random Number for Range of Rows of Any Table - Very interesting Question from Reader — 6 comments

pinaldave wrote 5 months ago: Just a day ago I received email from reader how to get single random number for range of rows of any … more →

Tags: Pinal Dave, Reader's question, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - Remove Duplicate Entry from Comma Delimited String - UDF — 5 comments

pinaldave wrote 5 months ago: I love reader’s contribution this blog as that brings variety in articles. I encourage my read … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, SQL Authority, Pinal Dave, T-SQL, SQL Scripts

SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice - Part 2 — 2 comments

pinaldave wrote 8 months ago: A year ago I wrote post about SQL SERVER – Retrieve – Select Only Date Part From DateTi … more →

Tags: Best Practices, Pinal Dave, SQL, SQL Authority, SQL DateTime, SQL Performance, SQL Query, SQL Scripts, SQL Server

SQL SERVER - Get Numeric Value From Alpha Numeric String - UDF for Get Numeric Numbers Only — 5 comments

pinaldave wrote 8 months ago: SQL is great with String operations. Many times, I use T-SQL to do my string operation. Let us see U … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Tips and Tricks, SQL Authority, Pinal Dave, T-SQL, SQL Scripts

SQL SERVER - 2008 - Enhenced TRIM() Function - Remove Trailing Spaces, Leading Spaces, White Space, Tabs, Carriage Returns, Line Feeds — 7 comments

pinaldave wrote 8 months ago: After reading my article SQL SERVER – 2008 – TRIM() Function – User Defined Functi … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, sqlcmd

SQL SERVER - 2008 - TRIM() Function - User Defined Function — 5 comments

pinaldave wrote 8 months ago: I just received following question in email by James Louren. “How come SQL Server 2000, 2005 d … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL, technology

SQL SERVER - Get Answer in Float When Dividing of Two Integer — 6 comments

pinaldave wrote 9 months ago: Many times we have requirements of some calculations amongst different fields in Tables. One of the … more →

Tags: Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T-SQL, technology

SQL SERVER - Guidelines and Coding Standards Complete List Download — 5 comments

pinaldave wrote 9 months ago: SQL SERVER – Guidelines and Coding Standards complete List Download Coding standards and guide … more →

Tags: Best Practices, Data Warehousing, Database, dba, Pinal Dave, SQL, SQL Authority, SQL Coding Standards, SQL Constraint and Keys

SQL SERVER - 2008 - Interview Questions and Answers Complete List Download — 39 comments

pinaldave wrote 9 months ago: Download SQL Server 2008 Interview Questions and Answers Complete List Interview is very important e … more →

Tags: Database, Pinal Dave, SQL, SQL Authority, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL DateTime, SQL Documentation

SQL SERVER - 2008 - Interview Questions and Answers - Part 8 — 3 comments

pinaldave wrote 9 months ago: SQL SERVER – 2008 – Interview Questions and Answers Complete List Download What is Data … more →

Tags: Data Warehousing, Database, Pinal Dave, SQL, SQL Authority, SQL Data Storage, SQL Index, SQL Interview Questions and Answers, SQL Query

SQL SERVER - 2008 - Interview Questions and Answers - Part 6 — 4 comments

pinaldave wrote 9 months ago: SQL SERVER – 2008 – Interview Questions and Answers Complete List Download 3) Questions … more →

Tags: technology, SQL Server, SQL, SQL Query, Database, SQL Tips and Tricks, SQL Index, SQL Authority, Pinal Dave

SQL SERVER - 2008 - Interview Questions and Answers - Part 4 — 6 comments

pinaldave wrote 9 months ago: SQL SERVER – 2008 – Interview Questions and Answers Complete List Download 1) General Qu … more →

Tags: technology, SQL Server, SQL, SQL Query, SQL Stored Procedure, SQL Constraint and Keys, Database, SQL Tips and Tricks, SQL Index


Have your say. Start a blog.

See our free features →

Related Tags
All →

Follow this tag via RSS

Find other items tagged with “sql-function”:
Technorati Del.icio.us IceRocket