Code:
INSERT [dbo].[ImportMail]
([WorldID],[ToName],[OrgObjID],[Count],[Durable],[ExValue],[ImageObjectID],[Ability],[Title],[Content],[Money],[Money_Account],[Money_Bonus],[GmName],[Serial],[CreateTime]) VALUES
(1,@ToPlayer,214640,1,@EQDurable,@WEPExValue,214640,@MainWep1H,N'Welcome',N'Hi',0,0,0,N'System',@Serial,@CreateTime),
(1,@ToPlayer,214639,1,@EQDurable,@WEPExValue,214639,@MainWep2H,N'Welcome',N'Hi',0,0,0,N'System',@Serial,@CreateTime),
(1,@ToPlayer,212931,1,@EQDurable,@EQExValue,212931,@RangeWep,N'Welcome',N'Hi',0,0,0,N'System',@Serial,@CreateTime),
(1,@ToPlayer,234068,1,@EQDurable,@EQExValue,234068,@Tally,N'Welcome',N'Hi',0,0,0,N'System',@Serial,@CreateTime);
How would I make the @Serial be regenerated in this INSERT example above.
Bookmarks