Ars Technica

SQL Syntax for Updating datetime Field

I just added a field, 'ExportDate' to a table (AYP) in my MS SQL 2000 database. Since I added the field to an existing table, the values for 'ExportDate' in all records is <null>. What I need to do is ...
dbta

Redgate Software is Updating its SQL Server Monitoring Platform

Redgate Software is releasing SQL Monitor v7, adding a reporting suite to the SQL Server monitoring tool. The new feature can instantly generate accurate, informative reports on the performance of SQL ...
Ars Technica

[SQL] Updating Multiple Records Using Non-Primary Key

I'm trying to update multiple records using a non-primary key. However, it only updates the first row it finds and not all rows. Is this possible or do updates require a primary key (and therefore) ...