摘要:
一、遇到的问题:关于SQL中的cast、convert函数解决方法:CAST ( expression AS data_type )例:cast(cast(ONLineQty*100/(select sum(ONLineQty) from @tablevar) as decimal(10,2)) as varchar) +'%'CONVERT (data_type[(length)], expression [, style])例:SELECT CONVERT(varchar(10),getdate(),121) now 得:2005-12-31SELECT CONVERT(v 阅读全文