compatible with MS SQL Server 2000

BEGIN / END se izpolva kogato imash izpylnenieto na niakolko queries. Mojesh da izpolvash i BEGIN TRANSACATION no v sluchaia e napylno bezmisleno. OSven tova za da update-tvash poveche oyt edna tablica, triabva da syzdadesh ALIAS mejdu tablicite, eto ti i primer:
------------------------
UPDATE AliasA
SET pole2 = Table2.pole2
FROM Table1 AS AliasA
INNER JOIN Table2
ON Alias1.pole1 = Table2.pole1

------------------


/* i procedurata */

create stored procedure spUpdate_myprocedure

AS
BEGIN

UPDATE AliasA
SET pole2 = Table2.pole2
FROM Table1 AS AliasA
INNER JOIN Table2
ON AliasA.pole1 = Table2.pole1

UPDATE AliasB
SET pole3 = Table3.pole1
FROM Table1 AS AliasB
INNER JOIN Table3
ON AliasB.pole1 = Table3.pole1

i t.n.

END
GO