How to set Foreign Key in SQL Server

Foreign Key in SQL: A foreign key is a column attribute which is used to link multiple tables in a database. A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table. The table containing the foreign key is called the child table, and the table containing the candidate key is called… Continue reading How to set Foreign Key in SQL Server

How to set the ID as primary key and Auto increment in SQL Server

In most cases, it is necessary or a best practice to set id as a primary key of a database table. MS SQL Server is one of the most popular Database server. In this very quick tutorial we will learn two methods to set a table column as a primary key and auto increment. Tools… Continue reading How to set the ID as primary key and Auto increment in SQL Server

How to Insert values into MS SQL Server using C#

In this tutorial, we will learn how to insert values into MS SQL Server using C#. For this specific tutorial, we’ll use Windows forms application which is a very popular platform for designing and development of desktop applications C#. You can also use this technique in Web Forms applications and WPF if you want. Tools… Continue reading How to Insert values into MS SQL Server using C#