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…
Sql Server – Union and Union All
Union and Union All, both are used to select data from one or more than one tables but still they…
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…
Difference between Primary key and Unique key
var gaJsHost = ((“https:” == document.location.protocol) ? “https://ssl.” : “http://www.”); document.write(unescape(“%3Cscript src='” + gaJsHost + “google-analytics.com/ga.js’ type=’text/javascript’%3E%3C/script%3E”)); try { var…
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…