Sql Server View
Views:- View can be described as virtual table which derived its data from one or more than one table columns.It…
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…