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

SQL SERVER – Difference Between @@Version and xp_msver – Retrieve SQL Server Information

October 22, 2007

SQL Function, SQL Scripts, SQL Stored Procedure, SQL System Table

Just a day ago, I was asked which SQL Server version I am using. I said SQL Server 2005. However, the person I was talking was looking for more information then that. He requested more detail about the version. I responded with SQL Server 2005 Service Pack 2. After the…

SQL SERVER – UDF vs. Stored Procedures and Having vs. WHERE

October 10, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Function, SQL Stored Procedure

Read my First Article in SQL Server Magazine – Oct 2007 [Articles are relocated so links are disabled] Reference : Pinal Dave (https://blog.sqlauthority.com)

SQL SERVER – 2005 – Sample Example of RANKING Functions – ROW_NUMBER, RANK, DENSE_RANK, NTILE

October 9, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Ranking Functions, SQL Function, SQL Scripts

I have not written about this subject for long time, as I strongly believe that Book On Line explains this concept very well. SQL Server 2005 has total of 4 ranking function. Ranking functions return a ranking value for each row in a partition. All the ranking functions are non-deterministic.…

SQL SERVER – Two Connections Related Global Variables Explained – @@CONNECTIONS and @@MAX_CONNECTIONS

September 29, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Transactions

Few days ago, I was searching MSDN and I stumbled upon following two global variables. Following variables are very briefly explained in the BOL. I have taken their definition from BOL and modified BOL example to displayed both the global variable together. @@CONNECTIONS Returns the number of attempted connections, either…

SQL SERVER – UDF – Validate Positive Integer Function – Validate Natural Integer Function

September 18, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Few days ago I wrote SQL SERVER – UDF – Validate Integer Function. It was very interesting to write this and developers at my company started to use it. One Jr. DBA modified this function to validate only positive integers. I will share this with everybody who are interested in…

SQL SERVER – Difference Between UPDATE and UPDATE()

September 17, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

What is the difference between UPDATE and UPDATE()? UPDATE is syntax used to update the database tables or database views. USE AdventureWorks ; GO UPDATE Production.Product SET ListPrice = ListPrice * 2; GO UPDATE() is used in triggers to check update/insert to the database tables or database views. Returns a…

SQL SERVER – UDF – User Defined Function – Get Number of Days in Month

September 8, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

Following User Defined Function (UDF) returns the numbers of days in month. It is very simple yet very powerful and full proof UDF. CREATE FUNCTION [dbo].[udf_GetNumDaysInMonth] ( @myDateTime DATETIME ) RETURNS INT AS BEGIN DECLARE @rtDate INT SET @rtDate = CASE WHEN MONTH(@myDateTime) IN (1, 3, 5, 7, 8, 10,…