View Single Post
  #6 (permalink)  
Old November 12th, 2011, 09:55 PM
NovicePGM2011 NovicePGM2011 is offline
Authorized User
Points: 53, Level: 1
Points: 53, Level: 1 Points: 53, Level: 1 Points: 53, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2011
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here is an example of a table for a store:

In this table I would like to use the Stored Procedure to
update all aspects of the tblStore using the storeName and the StoreBranch as a specifier in a where clause.

So if I have multiple stores I can only update one.


Code:
CREATE TABLE tblStore(
StoreName       VARCHAR(30),
StoreBranch     VARCHAR(30),
CONSTRAINT pktblStore PRIMARY KEY (StoreName, StoreBranch),
StoreAddress    VARCHAR(30) NOT NULL,
StoreCity       VARCHAR(30) NOT NULL,
StoreState      CHAR(2) NOT NULL,
StoreZip        CHAR(9)  NOT NULL,
StorePhone      CHAR(10) NOT NULL,
);
Just needed to illustrate my thinking.

Novice
Reply With Quote