طلب query

[uleader2]

انا عايز query ترتبلي id ref_objcommon علشان اضيف بغداد لان ال query بتاعت اخر id شكلها مش شغال و كل مرة بيجيبلي ايرور

[aaaaa200123]

متجيب داتا بيز جهزة احسن

[[Dev] Arshivel]

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))

سلاموز

[uleader2]

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 بال query ده