日期:2014-05-17 浏览次数:20454 次
select * from Student where ID='S'+ltrim(convert(int,right('S2011012',7)-1))union all select * from Student where ID='S'+ltrim(convert(int,right('S2011012',7)+1))