SQL Tips and Tricks Archives - Page 300 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Introduction to expressor 3.4 Lookup Tables

September 14, 2011

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 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 – 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 – 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()