Creating New Objects with Auto Numbering

This walkthrough demonstrates inserting records with an auto-number property and a calculated field that depends on it.

Get Records

EXEC dbo.spMFUpdateTable 'MFMyDocn', 1;

View Results

SELECT * FROM dbo.MFMydocn;

First Iteration

INSERT INTO dbo.MFMydocn (
   Autonumber,
   Calculated,
   Name_Or_Title,
   Process_ID
)
VALUES (
   0, 'auto', 'First record', 1
);

EXEC dbo.spMFUpdateTable 'MFMyDocn', 0;

SELECT * FROM dbo.MFMydocn;

Second Iteration

INSERT INTO dbo.MFMydocn (
   Autonumber,
   Calculated,
   Name_Or_Title,
   Process_ID
)
VALUES (
   0, 'auto', 'First record', 1
);

EXEC dbo.spMFUpdateTable 'MFMyDocn', 0;

Update Title (Non-related to Auto Number)

UPDATE mm
SET mm.Process_ID = 1, mm.Name_Or_Title = 'Updated record'
FROM dbo.MFMydocn AS mm
WHERE id = 1;

EXEC dbo.spMFUpdateTable 'MFMyDocn', 0;