MBox-Tutorials: SQL-SERVER

Home / SQL-SERVER

Showing posts with label SQL-SERVER. Show all posts

Coding Standards and Guidelines for Database

Coding Standards and Guidelines for Database ANSI SQL 92 standards have to be followed for writing queries. Do not put order by...

CRUD Operations also called(Create,Read,Update,Delete) Today I will explain how to perform CRUD operations in easy way. Add the following ...

What is an Index? Indexes of SQL Server are similar to the indexes in books. They help SQL Server retrieve the data quicker. Index is ...

Get all employee detail from EmployeeDetail table whose "EmployeName" start with any single character between 'd-m' S...

Stored Procedures are pre-compiled objects which are compiled for first time and its compile format is saved which gets executed whenever ...

ExecuteNonQuery() It Returns the count of Rows Effected by the Query. Int in Return Type. ExecuteNonQuery() works Queries only. Create,Alt...

DataSet: DataSet can fetch multiple TableRows at a time. A DataSet is like structure which has collection of DataTables. DataSet, D...

DataReader 1.Can Access one table at a Time. 2.Handles DataBase Tables. 3.Only READ Operation. 4.DataBase Connection M...

Insert procedure CREATE PROCEDURE sp_insert @name varchar(50), @password nvarchar(12) AS begin insert into tbl_login...

Stored Procedures/Procedure: A stored procedure is a database object which contains precompiled queries. Stored Procedures are a block of co...

JOINS IN SQL: Joins are used for retrieving the data from one or more tables at a time. Joins can be classified into the following types. E...