摘要： --select查询结果为常量select 1 select 'select'--alias 别名的使用select 1 as aa select stuNo as id from stuInfo--列别名select s.stuNO From StuInfo as s --表别名--数据类型的转化 cast convertselect CAST(stuNo as varchar(10)) as NewstuNo from stuInfo select CONVERT(varchar(10),stuNo) as NewStuNo from stuInfo--时间日期的格式化se 阅读全文