Tag Archives: SQL Advance Concepts

CTE command In Sql Server

Posted on January 17, 2012 by vivekjohari

Common table expression (CTE):- Common table expression or CTE can be described as the temporary, named record set return by the execution of the query (insert, delete, update, select or update view statement). It is not stored as an object … Continue reading →

Posted in Most Imp SQL Concepts, SQL CTE, 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

Sql Server View

Posted on January 31, 2010 by vivekjohari

Views:- View can be described as virtual table which derived its data from one or more than one table columns.It is stored in the database. It is used to implements the security mechanism in the Sql Server. For example, suppose … Continue reading →

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

Indexes in Sql server

Posted on January 3, 2010 by vivekjohari

Indexes-Indexing  is way to sort and search records in the table. It will improve the speed of locating and retrieval of records from the table.It can be compared with the index which we use in the book to search a … Continue reading →

Posted in Most Imp SQL Concepts, SQL Indexes, SQL Server | Tagged , | 25 Comments

Difference between Clustered Index and Non clustered Index

Posted on January 3, 2010 by vivekjohari

Indexes-Indexing  is way to sort and search records in the table. It will improve the speed of locating and retrieval of records from the table.It can be compared with the index which we use in the book to search a … Continue reading →

Posted in Imp SQL Difference, Interview Questions, SQL Indexes, SQL Server | Tagged , , | 31 Comments