-- Collection of code snippets by Arne Vajhøj 
-- posted to eksperten.dk, usenet and other places (2002-now) 
CREATE TABLE dectbl (decfld DECIMAL(18,2))
GO

CREATE PROCEDURE decsp(@decval    DECIMAL(18,2))
AS
INSERT INTO dectbl(decfld) VALUES(@decval)
GO

SELECT * FROM dectbl
GO

EXEC decsp 123.45
GO

EXEC decsp 678.90
GO

SELECT * FROM dectbl
GO
