Database design for Inventory application

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Database design for Inventory application

Author

Topic

RPAT
Starting Member

1 Post

Posted - 2012-11-10 : 08:26:43

Hi ,

I am designing a Database for Inventory , my requirement is where we will purchase a product ,we should maintains its count and whenever we do sale the product the item count should be decremented.

Please advice how to design a database for this .
Thanks in advance

GetSome
Starting Member

4 Posts

Posted - 2012-11-19 : 19:10:37

Create Database Inventory
Go
Use Inventory
Go
Create Table Items (Item varchar(50), [Count] Int)
Go

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources