Subscribe to this blog
Vivek's SQL Notes
Vivek johari is currently a Analyst and
have more that 5.5 yeras of experience in database. He has Master
degree in Computer and also he is Microsoft certified Sql DBA
(MCTS)& Microsoft certified SQl BI professional(MCTS). He is also
Oracle certified profession(OCP)DBA in ORACLE 10g and ORACLE 9i.He has
the experience of working in PL/SQL, T-SQL and SSIS/SSRS. His work
basically involved designing and optimization of the Database.He has
also published many database articles on his blog Technologies with Vivek Johari.
Archives: April 2012
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 Insertion, deletion and update statements.) It has…
2 comments, 536 reads
Posted in Vivek's SQL Notes on 17 April 2012
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…
1. How to add a column
2. How to update a column
3. How to drop a column
Suppose…
2 comments, 493 reads
Posted in Vivek's SQL Notes on 15 April 2012
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 the data into the table,…
0 comments, 920 reads
Posted in Vivek's SQL Notes on 15 April 2012
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 table. It turns the…
6 comments, 10,409 reads
Posted in Vivek's SQL Notes on 14 April 2012