SQL Archives - Page 293 of 519 - SQL Authority with Pinal Dave

SQL SERVER – Denali – String Function – FORMAT() – A Quick Introduction

September 17, 2011

In SQL Server Denali, there are two new string functions being introduced, namely: CONCAT() FORMAT() Today we will quickly take a look at the FORMAT() function. FORMAT converts the first argument to specified format and returns the string value. This function is locale-aware and it can return the formatting of…

SQL SERVER – Introduction to expressor 3.4 Lookup Tables

September 14, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In this blog post, I am going to take a closer look at expressor’s new and extremely versatile implementation of lookup tables, which they are releasing as part of the upcoming expressor 3.4 product release. As creation and use of the lookup table can be managed completely through simple-to-use graphical…

SQL SERVER – Denali – New Functions and Shorthand for CASE Statement

September 13, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

This blog post is written in response to the T-SQL Tuesday post of Data Presentation. This is a very interesting subject. I recently started to write about Denali Logical and Comparison functions. I really enjoyed writing about new functions, but there was one question kept cropping up – is the…

SQL SERVER – Denali CTP3 – Step by Step Installation Video – 200 Seconds

September 12, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

SQL Download

My recent article on SQL SERVER – Download Denali CTP3 and Denali CTP 3 Product Guide has inspired today’s post. After reading this blog post, I received a few emails and few comments on facebook page that if I can post a video guide to Denali CTP3 installation. Finally I create…

SQL SERVER – DBA Quiz 2011 – All was well few moments before all went wrong – Reasons and Resolutions

September 12, 2011

Pinal Dave

SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks

My question just got published at DBA Quiz 2011. This question is inspired from a real life incident, which occurred to me a few years ago. That time, I was a DBA myself and then one fine day, everything went south. When we checked the log, all the logs were…

SQL SERVER – Denali – Logical Function – IIF() – A Quick Introduction

September 10, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

In SQL Server Denali, there are two new logical functions being introduced, namely: IIF() CHOOSE() Today, we will have a look at the IIF() function. This function does not need any introduction as developers have used this function in various languages from ages. This function is shorthand way for writing…

SQL SERVER – Denali – Conversion Function – TRY_CONVERT() – A Quick Introduction

September 8, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

In SQL Server Denali, there are three new conversion functions being introduced, namely: PARSE() TRY_PARSE() TRY_CONVERT() Today we will quickly take a look at the TRY_CONVERT() function. The TRY_CONVERT() function is very similar to CONVERT function which is avail in SQL Server already. Only difference is that it will attempt…