SQL Scripts Archives - Page 281 of 318 - SQL Authority with Pinal Dave

SQL SERVER – Dynamic Case Statement – FIX : ERROR 156 : Incorrect syntax near the keyword

February 28, 2008

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

One of my friend sent me query asking me how to generate dynamic case statements in SQL. Every time he tries to run following query he is getting Error 156 : Incorrect syntax near the keyword. He was frustrated with following two queries. There are two different ways to solve…

SQL SERVER – SELECT 1 vs SELECT * – An Interesting Observation

February 26, 2008

Pinal Dave

SQL Performance

SQL Scripts, SQL Server

Many times I have seen issue of SELECT 1 vs SELECT * discussed in terms of performance or readability while checking for existence of rows in table. I ran quick 4 tests about this observed that I am getting same result when used SELECT 1 and SELECT *. I think smart readers of this blog will come up the situation when SELECT 1 and SELECT * have different execution plan when used to find existence of rows.

SQL SERVER – Find All The User Defined Functions (UDF) – Part 2

February 22, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts

Few days ago, I wrote about SQL SERVER – Find All The User Defined Functions (UDF) in a Database. Regular reader of this blog Madhivanan has suggested following alternate method to do the same task of finding all the user defined functions in database. USE AdventureWorks GO SELECT specific_name,specific_schema FROM…

SQL SERVER – UDF to Return a Calendar for Any Date for Any Year

February 20, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts

It gives me great pleasure to write articles like today’s one because I have received great comment from one of regular reader who has taken UDF written by me and created another UDF using that UDF which enhances functionality of it. I had written previous article about SQL SERVER –…

SQL SERVER – How to Escape Single Quotes – Fix: Error: 105 Unclosed quotation mark after the character string

February 17, 2008

Pinal Dave

SQL Interview Questions and Answers

SQL Error Messages, SQL Scripts, SQL Server, SQL String

Jr. Developer asked me other day how to escape single quote?
User can escape single quote using two single quotes (NOT double quote).

SQL SERVER – Get Current Database Name

February 12, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Yesterday while I was writing script for SQL SERVER – 2005 – Find Unused Indexes of Current Database . I realized that I needed SELECT statement where I get the name of the current Database. It was very simple script. SELECT DB_NAME() AS DataBaseName It will give you the name…

SQL SERVER – 2005 – Find Unused Indexes of Current Database

February 11, 2008

Pinal Dave

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

SQL Index, SQL Scripts

Simple but accurate following script will give you list of all the indexes in the database which are unused. If indexes are not used they should be dropped as Indexes reduces the performance for INSERT/UPDATE statement. Indexes are only useful when used with SELECT statement. Script to find unused Indexes.…