Blogs about: Sql Function

Featured Blog

SQL SERVER - Connect Item - Vote for Feature Request Function TRIM3 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 Name4 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 Network8 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 Display11 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 Reader6 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 - UDF5 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 22 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 Only5 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 Feeds7 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 Function5 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 Integer6 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 Download5 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 Download39 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 83 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 64 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 46 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