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

SQL SERVER – How to Flip Value of Bit Field in SQL Server?

October 25, 2014

How do you flip bit field in SQL Server? Well, if you search for this question on internet, you will find many different answers, today we will see my favorite method to flip value for the bit field. Bit field can hold two different values zero (0) and one (1).…

SQL SERVER – Search Records with Single Quotes – Part 2

October 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Yesterday I wrote a blog post about and it has created quite a lot of interest in the community SQL SERVER – Search Records with Single Quotes. Here are a few other alternatives which I received as a comment. The question was how to search records with single quotes in…

SQL SERVER – Search Records with Single Quotes

October 20, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

Every day when I woke up there are hundreds of emails with various questions related to SQL. I spend my first hour of the day answer each of them. How do I search records with single quotes in it? Here is the answer to find records with single quotes in…

SQL SERVER – Beginning Reading Transaction Log File

October 15, 2014

Pinal Dave

SQL

Devart, SQL Log, SQL Scripts, SQL Server

In this article we will examine what the SQL Server Transaction Log is, why do we need one and how it works.

SQL SERVER – Add Auto Incremental Identity Column to Table After Creating Table

October 11, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Identity, SQL Scripts

Question: Is it possible to add an auto incremental identity column to any table in SQL Server after creating a table. Answer: There are two answers – No and Yes. Let us see them one by one. Answer No – If you have an integer column in your table and…

SQL SERVER – GROUP BY Columns with XMLPATH – Comma Delimit Multiple Rows

October 3, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server

This is one of the most popular question and I keep on getting again and again in email, Facebook and on social media. I have decided to write about it here in the blog so in future I can directly give a reference. Here is the question – there is…

SQL SERVER – UPDATE FROM SELECT Statement with Condition

September 30, 2014

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Table Operation

An email from an old college friend landed my mailbox about UPDATE FROM SELECT Statement with Condition:
“Hey Pinal,”
I have two tables. I want to conditionally update data in one table based on another table. How can I do that. I have included sample scripts and an image for further explanation.