Syndicated Blogs - Technology With Vivek Johari

Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked


	Syndicated Blogs

Upload Image

Close it

Select File

This blog contains various articles on the SQL Server. Also this blog contains various interview questions on the SQL Server. Through this blog I try to make the learning of SQL Server/ BI and SQL DBA very easy and in a quick time.


	Like

Invite Friends

Browse by Tags · View All

CodeProject	6
Sql Server	4
Having Clause	3
Interview Questions on sql server	3
SQLServerPediaSyndication	3
Happy New Year	1
Rebuild And Reorganization of Indexes	1
Replication in SQL Server	1
Fragmentation in SQL Server	1
Log Shipping in SQL Server	1

Archive · View All

February 2012	20
December 2012	5
April 2012	4
August 2012	2
November 2010	2
November 2012	1
June 2012	1
May 2011	1
November 2011	1
October 2011	1

Technology With Vivek Johari

Home · Most Liked · Most Discussed · Fans (28) · Preferences

1
Liked

Merge Command In Sql Server

Merge Command:- Merge command is a new feature introduced in the SQL Server 2008. It can perform Update, Insert and delete operations at a single statement which means all the data is processed and read only once instead of three times(In case of Inserti...

Vivek Johari Posted on Apr 17 2012 6:15PM
Profile · Blog

3
Liked

1
Comments

Derived Table In Sql Server

Derived tables:- Derived tables are the tables which are created on the fly with the help of the Select statement. It is different from the temporary table in the way that in case of temporary table, first we have to create a temporary table, insert th...

Vivek Johari Posted on Apr 15 2012 12:00AM
Profile · Blog

1
Liked

Adding , Deleting and Updating a Column in a table

Many times we need to alter the table definition by adding , deleting or updating a column in the table. In this article, I am trying to explain the following :- 1. How to add a column 2. How to update a column 3. How to drop a column Suppose we have a ...

Vivek Johari Posted on Apr 15 2012 12:00AM
Profile · Blog

2
Liked

Pivot and Unpivot table in SQL SERVER

Pivot Table:- Pivot tables are used to summarize and display the data, specially in case of report data by means of aggregating the values. Pivot table can be used if we want to display the unique values of the column of a table as the columns of another...

Vivek Johari Posted on Apr 14 2012 12:00AM
Profile · Blog