ext.net.pro.1.0rc1（收藏）

use "Northwind" go /* DROP OBJECTS */ if exists (select * from sys.objects where name = 'Reset') drop procedure "Reset" GO CREATE PROCEDURE dbo.Reset /* ( @parameter1 int = 5, @parameter2 datatype OUTPUT ) */ AS BEGIN EXECUTE sp_executesql N' SET NOCOUNT ON set quoted_identifier on SET DATEFORMAT ymd use "Northwind" /* DROP PROCEDURES */ /* "CustOrderHist" "CustOrdersDetail" "CustOrdersOrders" "Employee Sales by Country" "Sales by Year" "SalesByCategory" "Ten Most Expensive Products" */ if exists (select * from sys.objects where name = ''CustOrderHist'') drop procedure "CustOrderHist" if exists (select * from sys.objects where name = ''CustOrdersDetail'') drop procedure "CustOrdersDetail" if exists (select * from sys.objects where name = ''CustOrdersOrders'') drop procedure "CustOrdersOrders" if exists (select * from sys.objects where name = ''Employee Sales by Country'') drop procedure "Employee Sales by Country" if exists (select * from sys.objects where name = ''Sales by Year'') drop procedure "Sales by Year" if exists (select * from sys.objects where name = ''SalesByCategory'') drop procedure "SalesByCategory" if exists (select * from sys.objects where name = ''Ten Most Expensive Products'') drop procedure "Ten Most Expensive Products" /* DROP VIEWS */ /* "Alphabetical list of products" "Current Product List" "Customer and Suppliers by City" "Invoices" "Order Details Extended" "Order Subtotals" "Orders Qry" "Products Above Average Price" "Products by Category" "Quarterly Orders" "Sales by Category" "Sales Totals by Amount" "Summary of Sales by Quarter" "Summary of Sales by Year" */ if exists (select * from sys.objects where name = ''Alphabetical list of products'') drop view "Alphabetical list of products" if exists (select * from sys.objects where name = ''Current Product List'') drop view "Current Product List" if exists (select * from sys.objects where name = ''Customer and Suppliers by City'') drop view "Customer and Suppliers by City" if exists (select * from sys.objects where name = ''Invoices'') drop view "Invoices" if exists (select * from sys.objects where name = ''Order Details Extended'') drop view "Order Details Extended" if exists (select * from sys.objects where name = ''Order Subtotals'') drop view "Order Subtotals" if exists (select * from sys.objects where name = ''Orders Qry'') drop view "Orders Qry" if exists (select * from sys.objects where name = ''Products Above Average Price'') drop view "Products Above Average Price" if exists (select * from sys.objects where name = ''Products by Category'') drop view "Products by Category" if exists (select * from sys.objects where name = ''Quarterly Orders'') drop view "Quarterly Orders" if exists (select * from sys.objects where name = ''Sales by Category'') drop view "Sales by Category" if exists (select * from sys.objects where name = ''Sales Totals by Amount'') drop view "Sales Totals by Amount" if exists (select * from sys.objects where name = ''Summary of Sales by Quarter'') drop view "Summary of Sales by Quarter" if exists (select * from sys.objects where name = ''Summary of Sales by Year'') drop view "Summary of Sales by Year" /* DROP TABLES */ /* "OrderDetails" "Orders" "Customers" "Shippers" "Products" "Categories" "Suppliers" "EmployeeTerritories" "Territories" "Region" "Employees" */ if exists (select * from sys.objects where name = ''OrderDetails'') drop table "OrderDetails" if exists (select * from sys.objects where name = ''Orders'') drop table "Orders" if exists (select * from sys.objects where name = ''Customers'') drop table "Customers" if exists (select * from sys.objects where name = ''Shippers'') drop table "Shippers" if exi�