例如: select cast ((A*100.00)/B as decimal(10,2)) as C from tableName 转自:http://crabdave.iteye.com/blog/395590