摘要:
微软从SQl2005起引入了CTE(Common Table Expression)以强化T-SQL。这是一个类似于非持久视图的好东西。正常的SQL语句:select * from person.StateProvince where CountryRegionCode in (select Cou... 阅读全文
摘要:
"UPDATE T_BuyDetails SET CommissionRatio =要更改的列名 FROM T_Users INNER JOIN T_BuyDetails ON T_Users.ID=T_BuyDetails.Id WHERE T_BuyDetails.Id =" + id //条... 阅读全文