sql server cast percent

++++++++++++++++++++++++++++++++

++++++++++++++++++++++++++++++++++++++++

在select语句中使用减法:
下面的示例返回公司每种图书的年度净收入。

USE pubs
GO
SELECT title,
   (
      (price * ytd_sales) * CAST( ( (100 - royalty) / 100.0 )
         AS MONEY)
      ) AS IncomeAfterRoyalty
FROM titles
WHERE royalty <> 0
ORDER BY title_id ASC
GO

括号可以用来更改执行的顺序。括号内的计算要首先执行。如果括号有嵌套，则最内层的计算优先

2. 在日期中使用减法:
USE pubs
GO
DECLARE @altstartdate datetime
SET @altstartdate = '1/10/1900 3:00 AM'
SELECT @altstartdate - 1.5 AS 'Subtract Date'