sample17.sql

T-SQL示例大全

/* 文件名称: Sample17.sql */

USE Northwind

SELECT 员工姓名 = FirstName + ' ' + LastName,
                      年龄 = DATEDIFF(yy,Birthdate,GETDATE())
  FROM Employees