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

SQL SERVER – Find Hostname and Current Logged In User Name

May 26, 2009

SQL Function, SQL Scripts, SQL Server, SQL Server Security

I work in an environment wherein I connect to multiple servers across the world. Time and again, my SSMS is connected to a myriad of servers that kindles a lot of confusion. I frequently use the following trick to separate different connections, which I mentioned in my blog sometime back…

SQL SERVER – Leading Zero to Number

April 24, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

I have received few emails asking how to prefix any number with zero. I have previously written two articles for the same subject. Please refer to my previous articles. SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number Display SQL SERVER – UDF – Pad…

SQL SERVER – Find All Servers From Local Network – Using sqlcmd – Detect Installed SQL Server on Network

March 18, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Utility, sqlcmd

I recently had requirement to create list of all the SQL Server on local network. I remembered that I had written similar script a year ago SQL SERVER – Script to Find SQL Server on Network. When I looked at it, I realize that I had written it for SQL…

SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display

March 16, 2009

Pinal Dave

SQL Tips and Tricks

Best Practices, SQL Function, SQL Scripts, SQL Server, SQL Utility

SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display. Let us learn more about this blog.

SQL SERVER – Pad Ride Side of Number with 0 – Fixed Width Number Display

March 10, 2009

Pinal Dave

SQL Tips and Tricks

Best Practices, SQL Function, SQL Scripts, SQL Server, SQL Utility

Today we will look something which is very quick and but quite frequently useful string operation over numeric datatype. This article is written based on a question asked by one of the users (name not disclosed as per request). Let us see how to show a fixed width number display.

SQL SERVER – Generate A Single Random Number for Range of Rows of Any Table – Very interesting Question from Reader

January 28, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Random, SQL Scripts

Just a day ago I received email from reader how to get single random number for range of rows of any table. The question was not very clear to me so I had asked him to send me question in simpler words. He sent me question back in simple words.…

SQL SERVER – Remove Duplicate Entry from Comma Delimited String – UDF

January 15, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

I love reader’s contribution this blog as that brings variety in articles. I encourage my readers to provide their contribution and I will publish then with their name. Blog Reader Ashish Jain has posted very simple script which will remove duplicate entry from comma delimited string. User Defined Function has…