المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : ineed Qurey Last ID in Common


Tigger
12-04-2014, 04:02 AM
ineed Qurey Last ID in Common

Hero
12-04-2014, 04:04 AM
اتفضل
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))

Tigger
12-04-2014, 04:05 AM
مشكوررررررررررررررررررررر:horse:

Hero
12-04-2014, 04:11 AM
##