spacer
Yehuda Shiran September 28, 2002
Installing IBuySpy's Sample DB
Tips: September 2002

Yehuda Shiran, Ph.D.
Doc JavaScript

Developer News
Microsoft Shows Off Silverlight 4, IE9 Plans
Metasploit Expands Vulnerability Test Framework
HyperCard Reborn?

IBuySpy Store comes with a sample database. Actually, it comes with a SQL script that can generate the database. The SQL script StoreDB.sql resides in the top level StoreDOCJS folder. The script will create a new database named StoreDOCJS, and will populate its tables with sample products, customers, and orders. To do this, invoke SQL Server Enterprise Manager, and choose Tools->SQL Query Analyzer. A new window will pop up. Load the SQL script by clicking on File->Open and browsing to the SQL script. If you follow our example above, the full path name should be C:\StoreDOCJS\StoreDB.sql. Once loaded, click on the Play button (right arrow) on the top menu bar. The StoreDOCJS database should be ready now.

To give you a taste of the SQL script, here is the code section that creates the Customers table:

  CREATE TABLE [dbo].[Customers] (
      [CustomerID] [int] IDENTITY (1, 1) NOT NULL ,
      [FullName] [nvarchar] (50) ,
      [EmailAddress] [nvarchar] (50) ,
      [Password] [nvarchar] (50) 
  ) ON [PRIMARY]
  GO

People who read this tip also read these tips:

Look for similar tips by subject:

internet.commediabistro.comJusttechjobs.comGraphics.com

Search:

WebMediaBrands Corporate Info

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | Shopping | E-mail Offers | Freelance Jobs

webref The latest from WebReference.com Browse >
Rolling Out Your Own HTML Application Version Control · HTML 5: Client-side Storage · Working with Ajax Server Extensions
Sitemap · Experts · Tools · Services · Email a Colleague · Contact FREE Newsletters 
 The latest from internet.com
Wi-Fi Product Watch, November 2009 · Chip Market Recovering From '08 Collapse · Low-Cost Tools to Kickstart Your New Business