IDENTITY Property in SQL Server
IDENTITY Property Sometimes we need a column whose values can uniquely identifying the rows in the table. To achieve […]
SQL Basic Concepts, SQL Server
SQL Basic Concepts, SQL Server
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
SQL Basic Concepts, SQL Server
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
Different ways to create a table and insert data into the table Read Post »
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
Difference between Subquery, Nested Subquery and Correlated Subquery
Query Query can be defined as a way to inquire the data from the database. It is used to extract
Difference between Subquery, Nested Subquery and Correlated Subquery Read Post »