Inventory Project using Mircosoft SQL Database
On my previous post you will see the unfinished GUI (not fully designed graphical user interface) and currently I am making the database in our project Inventory System. MSSQL Database (Microsoft SQL Database) is a relational database develop by microsoft this server can hold a huge datas.
On the picture below you will see my Insert Query.
I decided to use Microsoft SQL Database because in our project it is an inventory so it needs a huge storage to store.
I like using MSSQL because not only it store a huge data, it's queries can be separated on the front end software you're using (like C# Window Form) they are separated by putting your queries on the Stored Procedure. All your queries you make can be stored in the Stored Procedure of your database.
Here are my queries Stored on the Stored Picture (The red box).
Software used:
Microsoft SQL Server Management Studio 2017
Visual Studio 2017 Community Version (C# Window Form)


Thanks for using eSteem!
Your post has been voted as a part of eSteem encouragement program. Keep up the good work! Install Android, iOS Mobile app or Windows, Mac, Linux Surfer app, if you haven't already!
Learn more: https://esteem.app
Join our discord: https://discord.gg/8eHupPq