Union and Union All, both are used to select data from one or more than one tables but still they
Sql Server – Union and Union All
Continue reading
IDENTITY Property in SQL Server
IDENTITY Property Sometimes we need a column whose values can uniquely identifying the rows in the table. To achieve
Share 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
Share this:
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
Share this:
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
Share this:
Difference between Subquery, Nested Subquery and Correlated Subquery
Difference between Subquery, Nested Subquery and Correlated Subquery Query Query can be defined as a way to inquire the data
Share this:
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
