xxxtest.sql

来自「wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重」· SQL 代码 · 共 14 行

EXEC csp_CustomerDataRecord 'RATTC';
EXEC csp_CustomerDataRecord 'ALFKI';
EXEC csp_CustomerDataStream
EXEC csp_SalesOrderXML 11077
EXEC csp_SalesOrderXML_NS 11077
--Following requires installation of usp_GetOrdersAggregates stored procedure
--by running the StoreProceduresClient.sln project
--If the SalesOrders and SalesOrderItems tables are present, the project also
--installs the usp_GetSalesOrdersAggregates stored procedure
EXEC csp_LinearRegression 3, '5/1/1998', 12, 0
EXEC csp_LinearRegression 13, '5/1/1998', 12, 0
--Following requires SalesOrders and SalesOrderItems tables and stored procedure
--EXEC csp_LinearRegression 15, '1/1/2004', 12, 1