日期:2014-05-18 浏览次数:20579 次
declare @T table (col int) insert into @T select 13 union all select 15 union all select 17 union all select 18 union all select 19 select *,col%3 as col的余数 from @T /* col col的余数 ----------- ----------- 13 1 15 0 17 2 18 0 19 1 */
------解决方案--------------------