Check SQL Server 2000 Table Usage 
Thursday, June 12, 2008, 06:37 PM - DataBase
EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"

[ add comment ]   |  permalink  |  related link  |   ( 3 / 3374 )
SQL Server 2000 Update Data Inner Join Another Table 
Friday, June 6, 2008, 04:30 PM - DataBase
UPDATE table
SET values
FROM join other tables here.

Example

Update TableA
SET TableA.Col1=TableB.Col1
From TableA INNER JOIN TableB ON TableA.ID=TableB.ID

[ add comment ]   |  permalink  |  related link  |   ( 3 / 10479 )

BackBack