摘要:
USE AdventureWorks; GO UPDATE Sales.SalesPerson SET SalesYTD = SalesYTD + (SELECT SUM(so.SubTotal) FROM Sales.SalesOrderHeader AS so WHERE so.OrderDate = (SELECT MAX(OrderDate) FROM Sales.SalesOrderHe... 阅读全文
摘要:
select a.name 表名,b.name 列名 from sysobjects a,syscolumns b where a.id=b.id and b.name='表名' and a.type='U' 还算经常使用 转载自 http://www.cnblogs.com/dahuzizyd/archive/2007/02/02/sql.... 阅读全文