Tag Archives: CodeProject

SQL Server Functions- An Introduction

By | August 2, 2011

SQL FUNCTION: –    Function in a database can be defined as the code segment consisting of a logical group of SQL statements which takes some input arguments (if required), run in a sequential order and returns the output either in the form of a single value or in the form of a table.Through this… Read More »

Sql Server – How to write a Stored procedure in Sql server

By | December 5, 2009

Stored Procedure:- Stored Procedure In Sql server can be defined as the set of logically group of sql statement which are grouped to perform a specific task. There are many benefits of  using a stored procedure. The main benefit of  using a stored procedure is that it increases the performance of the database.The other benefits… Read More »

How to make database offline or online

By | October 13, 2009

Database is made offline to move its physical files. There can be many ways to make a database offline. But there are three main methods which are used frequently to make the database offline. These methods are given below:- CodeProject 1)With the help of Alter database Command:- We can make the database offline or online… Read More »

Different ways to create a table and insert data into the table

By | October 12, 2009

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. Some of the ways to create a table is given below:- 1)Creation of a table with the help of a create statement For… Read More »

Difference between Subquery, Nested Subquery and Correlated Subquery

By | September 29, 2009

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 the data from one table or multiple tables depending upon the user needs. Suppose we have a two tables Student and courses whose structure is given below:-… Read More »

Sql server Constraints – Primary Key, Foreign Key, Unique Key, Not Null, Check Constraints

By | August 19, 2009

Introduction A constraint is a property that is assigned to a column or a group of columns to prevent incorrect or corrupt data from entering into the tables. These constraints ensure the accuracy and reliability of the data into the tables. This article will tell about the Sql server Constraints – Primary Key, Foreign Key,… Read More »