摘要： --40、以班号和年龄从大到小的顺序查询Student表中的全部记录。select sno,sname,ssex,class,YEAR(GETDATE())-YEAR(sbirthday) from stu order by class desc,YEAR(GETDATE())-YEAR(sbirt 阅读全文

摘要： --简单赋值declare @a intset @a=5print @a --使用select语句赋值declare @user1 nvarchar(50)select @user1='张三'print @user1declare @user2 nvarchar(50)select @user2 = 阅读全文