SQL Server Archives - Page 298 of 348 - SQL Authority with Pinal Dave

SQL SERVER 2012 – DateTime Functions – DATEFROMPARTS() – DATETIMEFROMPARTS() – DATETIME2FROMPARTS()

September 19, 2011

SQL DateTime, SQL Function, SQL Scripts, SQL Server, SQL Server 2012

In SQL Server 2012, there are seven new datetime functions being introduced, namely:

DATEFROMPARTS ( year, month, day)
DATETIME2FROMPARTS ( year, month, day, hour, minute, seconds, fractions, precision )
DATETIMEFROMPARTS ( year, month, day, hour, minute, seconds, milliseconds )
DATETIMEOFFSETFROMPARTS ( year, month, day, hour, minute, seconds, fractions, hour_offset, minute_offset, precision )
SMALLDATETIMEFROMPARTS ( year, month, day, hour, minute )
TIMEFROMPARTS ( hour, minute, seconds, fractions, precision )
EOMONTH ()

SQL SERVER 2012 – String Function CONCAT() – A Quick Introduction

September 16, 2011

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server, SQL String

In SQL Server 2012, there are two new string functions being introduced, namely: CONCAT(), FORMAT(). In this blog post we are going to learn about String Function CONCAT(). CONCAT takes a minimum of two arguments to concatenate them, resulting to a single string.

SQL SERVER 2012 – Logical Function CHOOSE() – A Quick Introduction

September 11, 2011

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

In SQL Server 2012, there are two new logical functions being introduced, namely: IIF() and CHOOSE(). Today we will quickly take a look at the logical CHOOSE() function. This function is very simple and it returns specified index from a list of values. If Index is numeric, it is converted to integer. On the other hand, if the index is greater than the element in the list, it returns NULL.

SQL SERVER – Denali – Conversion Function – Difference between PARSE(), TRY_PARSE(), TRY_CONVERT()

September 9, 2011

Pinal Dave

SQL Tips and Tricks

SQL Function, SQL Scripts, SQL Server

In SQL Server Denali, three new conversion functions have been introduced, namely,

PARSE()
TRY_PARSE()
TRY_CONVERT()

SQL SERVER – Table Valued Functions – Day 26 of 35

August 26, 2011

Pinal Dave

SQL

Joes 2 Pros, SQL Function, SQL Scripts, SQL Server

Let us learn about table valued functions. Every day one winner from the United States will get Joes 2 Pros Volume 4.

SQL SERVER – Geography Data Type – Calculating Distance Between Two Points on the Earth – Day 18 of 35

August 18, 2011

Pinal Dave

SQL Tips and Tricks

Geography Data Type, Joes 2 Pros, SQL Scripts, SQL Server

In this blog post we will learn about Geography Data Type.

SQL SERVER – Ranking Functions – RANK( ), DENSE_RANK( ), and ROW_NUMBER( ) – Day 12 of 35

August 12, 2011

Pinal Dave

SQL Tips and Tricks

Joes 2 Pros, Ranking Functions, SQL Scripts, SQL Server

In this blog post we will discuss about Ranking Functions like RANK( ), DENSE_RANK( ), and ROW_NUMBER( ).

Ranking Functions (Part 1)

There are four ranking functions in SQL server. Today we will look at RANK( ), DENSE_RANK( ), and ROW_NUMBER( ).These functions all have the same basic behavior. Where they differ is in the handling of tie values. These three functions produce identical results, until a tying value in your data is present.