Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins
I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types…
Sql Server – How to write a Stored procedure in Sql server
Stored Procedure:- Stored Procedure In Sql server can be defined as the set of logically group of sql statement which…
IDENTITY Property in SQL Server
IDENTITY Property Sometimes we need a column whose values can uniquely identifying the rows in the table. To achieve this…
How to make database offline or online
Database is made offline to move its physical files. There can be many ways to make a database offline. But…
Different ways to create a table and insert data into the table
Introduction Tables can be defined as the structure which contains the data in the database. This article discuss about the…
Sql server Constraints – Primary Key, Foreign Key, Unique Key, Not Null, Check Constraints
Introduction A constraint is a property that is assigned to a column or a group of columns to prevent incorrect…