文章分类 -  SQL SERVER 2005

摘要：-- 1-1基本的 SELECT 敘述SELECT select_listFROM table_list-- 從每一行選出特定的欄位USE AdventureWorksGOSELECT ContactID,Title,FirstName,LastNameFROM Person.Contact-- 為每一列選出所有欄位USE AdventureWorksGOSELECT *FROM Person.C... 阅读全文

摘要：--顯性交易的運用-- Before countSELECT COUNT(*) BeforeCount FROM HumanResources.Department-- Variable to hold the latest error integer valueDECLARE @Error intBEGIN TRANSACTIONINSERT HumanResources.Department(... 阅读全文

摘要：--傳回平均值-- Average Product Review by ProductSELECT ProductID,AVG(Rating) AvgRatingFROM Production.ProductReviewGROUP BY ProductID-- Average DISTINCT Standard CostSELECT AVG(DISTINCT StandardCost) AvgDi... 阅读全文

只有注册用户登录后才能阅读该文。