Comparing data between tables seems like a simple thing to do, but it can eat up a lot of a SQL Server professional's time. Stephen Tirone shows how multiple assignment variables can be used to make this task a little easier.
2010-01-26
5,983 reads
The EXCEPT operator, introduced in SQL Server 2005, can be handy in some situations where you are comparing data between two tables. New author Stephen Tirone brings us a potential issue to be aware of with this operator.
2010-01-18
14,564 reads
By DataOnWheels
My first time at SQL Saturday New York City was an absolute blast! Thank...
By Chris Yates
Businesses rely on data for decision-making and strategy, but data silos hinder productivity. These...
Hi there I need help on creating a Linked Server to an MS Access...
Hi, I have a workstation with SQL Express 2019 installed and I have a...
Hello - I have attached a Word document here with details about my issue....
If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?
See possible answers