1
2 /* 改变一下数据大小,使相乘的积可以可以适合tinyint,其他无任何意义 */
3 update jobs set min_lvl = 10 ,max_lvl = 20 where job_id = 1
4
5 declare @max tinyint
6 update jobs set @max = max_lvl = max_lvl * min_lvl where job_id = 1
7 print @max
2 /* 改变一下数据大小,使相乘的积可以可以适合tinyint,其他无任何意义 */
3 update jobs set min_lvl = 10 ,max_lvl = 20 where job_id = 1
4
5 declare @max tinyint
6 update jobs set @max = max_lvl = max_lvl * min_lvl where job_id = 1
7 print @max