SQL??????????
????????? ???????[ 2010/5/12 15:28:27 ] ????????
??????????????????????????????????н?????????????????????????????????????????????ó???????????????????????????????????????κι?????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????ó?????????????????????????????????????????????????ó????????????????汾?????????μ??????????У??????????????????????????????????C#?? LINQ????????????????
???????????????????????NUnit???????????????????????????????C#??д???????????????????á?????? NUnit???????????http://www.nunit.org/index.php?p=download?????????????????????????????????????http://www.nunit.org/index.php?p=installation&r=2.5.2??????????????е??????????????????????????????????????????????????????Щ??????????????????????http://www.anydbtest.com?? AnyDBTest??????????????????????????????XML?????????????????????????????????????????????????????????????У?飬????Oracle??SQL Server??MySQL????
?????????????????????????????????????????????????????????????????????????磬?????PnL ????????а汾???????????????????????????????????PnL???????м????????????????????????????????μ?PnL??????ó???汾????????μ?PnL??????????????????????????е???μ?PnL??????ó??????????????????????????????????????????????μ???????????е???μ?PnL???schema??
????Use testDB
????GO
????CREATE TABLE OldPnLReport
????( AccountNumber int??
????NetSales decimal(9??2)??
????Costs decimal(9??2)??
????NetIncome decimal(9??2)??
????ReportDate smalldatetime
????)
????GO
????CREATE TABLE NewPnLReport
????( AccountNumber int??
????FurnitureSales decimal(9??2)??
????ServiceSales decimal(9??2)??
????Costs decimal(9??2)??
????NetIncome decimal(9??2)??
????ReportDate smalldatetime
????)
????GO
??????????NewPnLReport??FurnitureSales??ServiceSales???????NetSales??OldPnLReport??????????????Щ?????
????SELECT [AccountNumber]
??????[NetSales]
??????[Costs]
??????[NetIncome]
????FROM [testDB].[dbo].[OldPnLReport]
????WHERE ReportDate=??2009-10-16??
????GO
????SELECT [AccountNumber]
??????([FurnitureSales] + [ServiceSales]) as [NetSales]
??????[Costs]
??????[NetIncome]
????FROM [testDB].[dbo].[NewPnLReport]
????WHERE ReportDate=??2009-10-16??
????GO
?????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11