مشاهدة النسخة كاملة : ineed Qurey Last ID in Common
Tigger
12-04-2014, 04:02 AM
ineed Qurey Last ID in Common
اتفضل
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:
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions, Inc