declare @sc_name varchar(100)
declare cur_name cursor scroll keyset scroll_locks
for select sc_name
from eco_sc_baseinfo --for update of sc_name
for select sc_name
from eco_sc_baseinfo --for update of sc_name
open cur_name
fetch next from cur_name into @sc_name
fetch next from cur_name into @sc_name
while @@fetch_status=0
begin
if substring(@sc_name,1,12) = '佛山市南海区'
print substring(@sc_name,1,12)
else
print substring(@sc_name,1,12)--@sc_name
fetch next from cur_name into @sc_name
end
begin
if substring(@sc_name,1,12) = '佛山市南海区'
print substring(@sc_name,1,12)
else
print substring(@sc_name,1,12)--@sc_name
fetch next from cur_name into @sc_name
end
close cur_name
deallocate cur_name
deallocate cur_name
DECLARE abc CURSOR FOR
SELECT CompanyName
FROM Shippers
OPEN abc
FETCH NEXT FROM abc
UPDATE Shippers SET CompanyName = N'Speedy Express, Inc.'
WHERE CURRENT OF abc
WHERE CURRENT OF abc