CREATE PROCEDURE [Res]
as
-----------------------------------------------------------------------
update userdata set Loyalty = '0'where Authority = '255'
update userdata set LoyaltyMonthly = '0'where Authority = '255'
-----------------------------------------------------------------------
exec imbacodermyst
-----------------------------------------------------------------------
exec rank_knights
-----------------------------------------------------------------------
exec KNIGHTS_RATING_UPDATE
-----------------------------------------------------------------------
exec RANK_KNIGHTS
-----------------------------------------------------------------------
EXEC USER_KNIGHTS_RATING_UPDATE
-----------------------------------------------------------------------
EXEC UPDATE_PERSONAL_RANK
-----------------------------------------------------------------------
truncate table currentuser
----------------------------------------------------------------------
update userdata set Loyalty = '1' where Authority = '0'
update userdata set LoyaltyMonthly = '0' where Authority = '0'
----------------------------------------------------------------------
UPDATE USERDATA SET Authority='255'
WHERE strUserID='(select userid from gokhan)';
GO
Kullanım :
exec res
+rep plz