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.
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 InventoryGoUse InventoryGoCreate Table Items (Item varchar(50), [Count] Int)Go |
|
|
|
|
|