Stored Procedure:- Stored Procedure In Sql server can be defined as the set of logically group of sql statement which […]
Sql Server – How to write a Stored procedure in Sql server Read Post »
Union and Union All, both are used to select data from one or more than one tables but still they
IDENTITY Property Sometimes we need a column whose values can uniquely identifying the rows in the table. To achieve
Database is made offline to move its physical files. There can be many ways to make a database offline. But
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 »
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
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 »
Introduction A constraint is a property that is assigned to a column or a group of columns to prevent incorrect
The Perfect Mix of Technology & Knowledge