بيبقى مع الموضوع يا باشا على العموم اتفضل
كود PHP:
if
(@JobID= '787879')
BEGIN
DECLARE @USERJID int;
SET @USERJID = (SELECT USERJID FROM SRO_VT_SHARD.._USER WHERE CHARID = @CHARID);
IF (SELECT COUNT(*) FROM SRO_VT_ACCOUNT..SK_SILK WHERE JID = @USERJID) > 0
UPDATE SRO_VT_ACCOUNT..SK_SILK SET SILK_OWN = SILK_OWN + 5000 WHERE JID = @USERJID;
END