How to Create Database using Visual Studio 2013(SQL Server)

How to Create Database – Creating a Database is very common things in most of the developers, however for a beginner like me creating one is a bit of a struggle, especially if you are just starting to learn and understand programming. So I decided to create a simple instruction to share what I learn in different ways on how to access SQL Servers. If you

» Read more

How to create Stored Procedure in SQL Server

Store procedure is composed of Structured Query Language (SQL) which is found in a Relational Database Management System. Stored Procedure is used to store SQL queries that are mainly used to modify data from a Database. This is an alternative way in connecting our application to a database. In this tutorial Instead of embedding SQL Queries in our application we

» Read more