SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE [dbo].[MoneyTest](
        [id] [int] IDENTITY(1,1) NOT NULL,
        [money1] [decimal](18, 15) NULL,
        [money2] [decimal](18, 4) NULL,
     CONSTRAINT [PK_uMoneyTest] PRIMARY KEY CLUSTERED 
    (
        [id] ASC
    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
insert into moneytest 
(money1, money2) values
(£0.01,£0.01)

insert into moneytest 
(money1, money2) values
(£0.000000000000123,£0.000000000000123)

insert into moneytest 
(money1, money2) values
('0.000000000000123','0.000000000000123')



insert into moneytest 
(money1, money2) values
(£0.00005756,£0.00005756)
4 rows affected

select *
from moneytest


id
money1
money2


1
0.010000000000000
0.0100

2
0.000000000000000
0.0000

3
0.000000000000123
0.0000

4
0.000100000000000
0.0001

id	money1	money2
1	0.010000000000000	0.0100
2	0.000000000000000	0.0000
3	0.000000000000123	0.0000
4	0.000100000000000	0.0001