2014 m. kovo 12 d., trečiadienis

MS SQL: ciklas, palengvinantis atnaujinimą

declare @lastint integer = 44
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)

2014 m. kovo 6 d., ketvirtadienis

Blog, wiki, URL

Blog - weblog sutrumpinimas, online dienoraštis arba log'as
wiki - What I Know Is

URL - Uniform Resource Locator (dar žinomas kaip web address)

VB Page_Load įvykio vykdymas

 Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, Me.Load

End Sub


Du kartus naudojamas MyBase.Load, Me. Load rodo, kad Page_Load įvykis bus vykdomas du kartus.