Question

sql server 语句提示：消息 170,级别 15,状态 1,第 1 行第 1 行: '(' 附近有语法错误.

select * from S_Name,year(getdate())-year(birthday) as 年龄
from t_student

Answer 1

你衫信的SQL语法就错误了

应或李轮该是
select S_Name,year(getdate())-year(birthday) as 年龄 from t_student

select 查询字段 from 表扰哪名 where 条件