سؤال بسيط

[yehya77]

ممكن اعرف ازاى اجيب اخير ID فى ال SQL و ازاى اجيبة

[che_9299]

'Use SRO_VT_SHARD_INIT select ID from _RefObjCommon where CodeName128 like 'MOB_MAG_1ROC

[●♥ Marwan1337 ♥●]

USE SRO_VT_SHARD
DECLARE @CommonID INT
DECLARE @ItemLinkID INT
SET @CommonID = (SELECT ID FROM _RefObJCommon WHERE ID = (SELECT MAX(ID) FROM _RefObJCommon))+1
SET @ItemLinkID = (SELECT ID FROM _RefObJItem WHERE ID = (SELECT MAX(ID) FROM _RefObJItem))+1
print 'Common ID you have to use: '+cast(@CommonID as varchar(15))
print 'Common Link ID you have to use: '+cast(@ItemLinkID as varchar(15))

الكـويـرى ده هيجبلـك الـ ID , Link المتـاح ليـكـ أنـكـ تستخـدمـه..