DECLARE @Teams TABLE( Name varchar(100) ) INSERT INTO @Teams VALUES (N'GALATASARAY') INSERT INTO @Teams VALUES (N'LIVERPOOL') INSERT INTO @Teams VALUES (N'BARCELONA') INSERT INTO @Teams VALUES (N'PARIS SAINT GERMAIN') INSERT INTO @Teams VALUES (N'JUVENTUS') UPDATE @Teams SET Name = N'PORTO' WHERE Name = 'PARIS SAINT GERMAIN' SELECT @@ROWCOUNT --gives 1
