SQL Server 2014

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

create table A01
(Name_YA char(50),
Name_SA char(50),
Name_SY char(50),
QWE char(50),
ASL char(50));

INSERT INTO A01(Name_YA,Name_SA,Name_SY,QWE,ASL) 
VALUES (9009,123,321,331,1258);
SELECT * FROM A01
INSERT INTO A01(Name_YA,Name_SA,Name_SY,QWE,ASL) 
VALUES (9000,120,301,300,1258);
INSERT INTO A01(Name_YA,Name_SA,Name_SY,QWE,ASL) 
VALUES (9080,140,701,306,1257);


Name_YA
Name_SA
Name_SY
QWE
ASL


9009
123
321
331
1258


SELECT NAME% FROM A01 WHERE ASL=1258
Msg 156 Level 15 State 1 Line 1
Incorrect syntax near the keyword 'FROM'.