您现在正在浏览：站长之家 >> 数据库 >> 详细内容

将Access数据库移植到SQLServer

时间:2007-12-23 来源:不详作者:迈克DB

WHERE(((Orders.[ShippedDate])Between[BeginningDate]And[EndingDate]))
ORDERBY[LastName]&","&[FirstName],Employees.Country,Orders.[ShippedDate];

SQLServer7.0格式：

CREATEPROCEDUREEMP_SALES_BY_COUNTRY
@BeginningDatedatetime,
@EndingDatedatetime
AS
SELECTOrders.[OrderID],[LastName] "," [FirstName]ASSalesperson,Employees.Country,
Orders.[ShippedDate],[OrderSubtotals].SubtotalAS[SaleAmount]
FROMEmployeesINNERJOIN(OrdersINNERJ　　