[Dev.Ri3o]

المشاركة الأصلية كتبت بواسطة loverslove عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

Error

Msg 156, Level 15, State 1, Procedure _AddLogChar, Line 166
Incorrect syntax near the keyword 'begin'.

فى قوس ناقص
هتبقى كدة

If @EventID = 6 and exists (select * from SRO_VT_SHARD.._CharCOS where OwnerCharID = @CharID and refcharid in (select id from SRO_VT_SHARD.._refobjcommon where codename128 like '%COS_T%'))
BEGIN
update SRO_VT_SHARD.._InvCOS set itemid = 0 where COSID = (select id from SRO_VT_SHARD.._CharCOS where OwnerCharID = @CharID and RefCharID in (select id from SRO_VT_SHARD.._RefObjCommon where codename128 like '%COS_T%'))
update SRO_VT_SHARD.dbo._CharCOS set ownercharid = 0 where OwnerCharID = @CharID and RefCharID in (select id from SRO_VT_SHARD.._RefObjCommon where CodeName128 like '%COS_T%')
end