Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|SQL works but want to get the XML node data separately||11||30|
|SQL to JSON||14||39|
|ODBC settings not showng in FileMaker External Data Sources||6||23|
|Data encryption options between SQL DBs||3||31|