Comparison

Stairway to Advanced T-SQL

Stairway to Advanced T-SQL Level 11: Using Logical Operators

  • Stairway Step

SQL Server supports a number of different logical operators.  These operators can be used for testing Boolean conditions that return true, false and unknown in your T-SQL code.  Logical operators are useful for defining constraints to limit the rows be processed when selecting or updating data. This chapter will provide an overview of the logical […]

2020-10-09

132 reads

On Comparing Tables in SQL Server

  • Article

How do you compare two SQL tables? Every SQL Developer or DBA knows the answer, which is 'it depends'. It is not just the size of the table or the type of data in it but what you want to achieve. Phil Factor sets about to cover the basics and point out some snags and advantages to the various techniques.

2014-06-10

5,867 reads

Blogs

Solve SQL Server Resource Database Crash

By

Based on Microsoft Documentation <The Resource database is a read-only database that contains all...

Daily Coping 20 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

My 800th post!

By

It took me a little bit longer to get here than I expected but...

Read the latest Blogs

Forums

Poor peformance

By ramyours2003

I ran the update stats on a  table by creating the indexes, when i...

SQL Server data file distribution

By soumyarani0317

I am a newbie to SQL Server administration and config. Apologies if I appear...

Unable to get the last date from the query

By gazy007

Hi, Sorry if I couldn't find the correct section to post my question. I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers