declare @currint integer = 12
WHILE (@currint<@lastint)
BEGIN
UPDATE [SERVERIS].DuomenuBaze.dbo.EIF_questions
SET QLTText=(SELECT QLTText FROM EIF_questions where ID=@currint)
WHERE ID=@currint;
SET @currint = @currint + 1
END
Atnaujinti dalį duomenų
insert into [SERVERIS].DuomenuBaze.dbo.EIF_questions(ID, Col1, Col2, Col3)(select ID, Col1, Col2, Col3 from dbo.EIF_questions where ID>43)
Komentarų nėra:
Rašyti komentarą