Yearly Archives: 2011

SQL Server Functions- An Introduction

Posted on August 2, 2011 by vivekjohari

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 … Continue reading →

Posted in Most Imp SQL Concepts, SQL Functions, SQL Server | Tagged , , | 31 Comments

Cursor in SQL server

Posted on July 21, 2011 by vivekjohari

Sometimes our application required a database object which allows manipulation of data from a set of rows on row by row basic which means single row at a time. Cursor is the database object which solves this problem. With the use of … Continue reading →

Posted in Most Imp SQL Concepts, SQL Cursor, SQL Server | Tagged , , | 33 Comments

ACID Rules in Sql Server

Posted on May 28, 2011 by vivekjohari

ACID Rules This article will tell about the ACID Rules in SQL Server. It is a concept for evaluation of databases and their architecture. A:- (Atomicity) – Atomicity  states the principle of  All or none. This means that either all the SQL Statements within … Continue reading →

Posted in SQL ACID Rule, SQL Server | Tagged | Leave a comment

DML, DDL, DCL, TCL in SQL Server

Posted on May 28, 2011 by vivekjohari

Different Types of Sql Statements:-   DML DML is abbreviation of Data Manipulation Language. It is used to retrieve, store, modify, delete, insert and update data in database. Examples: SELECT, UPDATE, INSERT statements Select :- This Sql Statement is used … Continue reading →

Posted in SQL DDL, DML, DCL, TCL, SQL Server | Tagged | 32 Comments