Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
CREATE TABLE [dbo].[MTRANS] ([MTRANS_ID] int IDENTITY (1, 1) NOT NULL, [MBatch] int NULL, [MStatus] char(1) NULL ) CREATE PROCEDURE [prMCCARD_BATCH_INSERT] (@MTRANS_ID int OUTPUT, @MStatus char(1), @MBatch int OUTPUT ) As BEGIN Begin INSERT INTO [CCARD_BATCH]([MStatus]) VALUES (@MStatus) -- do magic here to increment/rollover MBatch ? End SELECT TRANS_ID = @@IDENTITY SELECT BATCH_NUMBER = ?? END