Ars Technica

T-SQL: update + variable + subquery + top N gives me incorrect syntax

I'm trying to assign rows in a table to a random variable entirely in Transact SQL (This is MS SQL Server 2000, sp3). I've got it working perfectly except I can't use a variable inside my subquery ...
Ars Technica

SQL, update w/ subquery = 0 rows affected

I'm having a bit of a problem with some SQL. I'm trying to do a match from one table to another. It works perfectly except for the last line. As soon as I add it NOTHING gets updated. I'm using SQL ...
Redmond Magazine

SQL Server 2000 Security Secrets

Despite the plentiful information in Books Online and on the official “SQL Server 2000 Security” document Microsoft offers online, setting up a truly secure SQL Server remains a difficult task. In ...
Simon Fraser University

Using a Pass-Through Query in a Subquery

Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...
Network World

Don’t play the victim – use the SQL Profiler deadlock graph

One of the dreaded error codes we get in the SQL log is the “1205”. It represents the infamous deadlock where two transactions are locking each other out. No way ...
Visual Studio Magazine

SQL Server 2022: Ledger, DDM and T-SQL Enhancements

Data developers are still learning about all the new goodies that arrived with SQL Server 2022, which is chock full of new features and enhancements such as ledger for blockchain security. Microsoft ...