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…