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 ...

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 ...

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 ...

RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from ...