SQL Server Archives - Page 103 of 393 - SQL Authority with Pinal Dave

SQL – Difference between != and <> Operator used for NOT EQUAL TO Operation

July 8, 2013

Here is interesting question received on my Facebook page. (On a side note, today we have crossed over 50,000 fans on SQLAuthority Facebook Fan Page). What is the difference between != and <>Operator in SQL Server as both of them works same for Not Equal To Operator? Very interesting question indeed.…

SQL SERVER – Check Database Level (IsNullConcat) and Session Level Settings (CONCAT_NULL_YIELDS_NULL) using T-SQL

July 7, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Earlier I wrote a blog post SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL and in follow up to the blog post, I received few questions. Let me try to answer those questions in following blog post. Q: How do we know if setting which returns NULL when concated to another NULL value is…

SQL SERVER – Weekly Series – Memory Lane – #036

July 6, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL

July 5, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function

Recently one of my friends sent me a SQL script to debug and I noticed that above all of his scripts he was executed following query. SET CONCAT_NULL_YIELDS_NULL OFF; This made me curious and I asked him reason why is he executes above script. He answered that when his application…

SQL SERVER – How to Refresh SSMS Intellisense Cache to Update Schema Changes

July 4, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Have you ever faced situation where you have just created or modified object but SSMS still shows the error. I quite often face this situation where I come across situation where my SSMS Intellisense Cache is not refreshed or updated. This is indeed very frustrating when you are presenting something…

Personal Technology – Excel Tip: Comparing Excel Files

July 2, 2013

Pinal Dave

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

Excel, Personal Technology

This guest post is by Vinod Kumar. Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Working on various versionsfrom SQL Server 7.0, Oracle 7.3 and other database technologies – he now works with the Microsoft Technology Center (MTC) as a Technology Architect. Let us read…

SQL SERVER – Check If Column Exists in SQL Server Table

July 1, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

A very frequent task among SQL developers is to check if any specific column exists in the database table or not. Based on the output developers perform various tasks. Here are couple of simple tricks which you can use to check if column exists in your database table or not.…