loaddata.sql

ASP.NET 建立和发布可自定义 Web 报表的指南

-- ===============================================
-- CONFIG ASP.NET Reports STARTER KIT DATABASE
-- Load Data Script
-- 
-- Version:	1.2 - 10/02 (mho)
--
-- ===============================================
USE [~~##RPTStarterKitDB##~~]
GO


SET DATEFORMAT mdy
GO

Insert Reports_Categories(CategoryName, Description) Values ('Beverages','Soft drinks, coffees, teas, beers, and ales')
Insert Reports_Categories(CategoryName, Description) Values ('Condiments','Sweet and savory sauces, relishes, spreads, and seasonings')
Insert Reports_Categories(CategoryName, Description) Values ('Confections','Desserts, candies, and sweet breads')
Insert Reports_Categories(CategoryName, Description) Values ('Dairy Products','Cheeses')
Insert Reports_Categories(CategoryName, Description) Values ('Grains/Cereals','Breads, crackers, pasta, and cereal')
Insert Reports_Categories(CategoryName, Description) Values ('Meat/Poultry','Prepared meats')
Insert Reports_Categories(CategoryName, Description) Values ('Produce','Dried fruit and bean curd')
Insert Reports_Categories(CategoryName, Description) Values ('Seafood','Seaweed and fish')

Insert Reports_Customers(CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax) Values  ('ALFKI', 'Alfreds Futterkiste',                  'Maria Anders',            'Sales Representative',           'Obere Str. 57',                                         'Berlin',          NULL,               '12209',      'Germany',         '030-0074321',              '030-0076545')
Insert Reports_Customers(CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax) Values  ('ANATR', 'Ana Trujillo Emparedados y helados',   'Ana Trujillo',            'Owner',                          'Avda. de la Constituci髇 2222',                         'M閤ico D.F.',     NULL,               '05021',      'Mexico',          '(5) 555-4729',             '(5) 555-3745')
Insert Reports_Customers(CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax) Values  ('ANTON', 'Antonio Moreno Taquer韆',              'Antonio Moreno',          'Owner',                          'Mataderos  2312',                                       'M閤ico D.F.',     NULL,               '05023',      'Mexico',          '(5) 555-3932',             NULL)
Insert Reports_Customers(CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax) Values  ('AROUT', 'Around the Horn',                      'Thomas Hardy',            'Sales Representative',           '120 Hanover Sq.',                                       'London',          NULL,               'WA1 1DP',    'UK',              '[phone]',           '[phone]')
Insert Reports_Customers(CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax) Values  ('BERGS', 'Berglunds snabbk鰌',                   'Christina Berglund',      'Order Administrator',            'Berguvsv鋑en  8',                                       'Lule