SQL Server 2017

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

create table ithelp_mssql_20190410
(dataall varchar(50),
 col_b varchar(50));
insert ithelp_mssql_20190410(dataall,col_b) 
values
('19930302','A'),
('19990312','B'),
('20030615','B'),
('20051112','B'),
('20090901','C'),
('20150130','A')
6 rows affected

select
                                          DATAALL                  ,
                                SUBSTRING(DATAALL, 1, 4)          a,
                                SUBSTRING(DATAALL, 1, 4)-1911     b,
            CONVERT(VARCHAR(3), SUBSTRING(DATAALL, 1, 4)-1911)    c,
      '0' + CONVERT(VARCHAR(3), SUBSTRING(DATAALL, 1, 4)-1911)    d,
RIGHT('0' + CONVERT(VARCHAR(3), SUBSTRING(DATAALL, 1, 4)-1911),3) e
from ithelp_mssql_20190410


DATAALL
a
b
c
d
e


19930302
1993
82
82
082
082

19990312
1999
88
88
088
088

20030615
2003
92
92
092
092

20051112
2005
94
94
094
094

20090901
2009
98
98
098
098

20150130
2015
104
104
0104
104

DATAALL	a	b	c	d	e
19930302	1993	82	82	082	082
19990312	1999	88	88	088	088
20030615	2003	92	92	092	092
20051112	2005	94	94	094	094
20090901	2009	98	98	098	098
20150130	2015	104	104	0104	104