Session on 15-10-13(FM)
· Second Max of Emp without using CTE (5th after 7th)
· Please write query for Retrieve Except colour Blue Records only
· What is Difference between Delete and Truncate
· Performance Tuning in SSIS
· Explain Flow draw of ForEachLoop Container with Example
· Difference between Function and SP
· Cluster and Non Cluster Indexes
· Write a Query for Below I/P and O/P
I/P
O/P
· What is O/P
Select 1
Union all
Select 1
· How to Create Cube (Clearly Explain)
· Second Max of Emp without using CTE (5th after 7th)
· Please write query for Retrieve Except colour Blue Records only
|
Product
Id
|
Name
|
Colour
|
|
1
|
Soap
|
Black
|
|
2
|
Vehicle
|
Blue
|
|
3
|
XXXX
|
Red
|
|
4
|
ZZZZ
|
Orange
|
|
5
|
AAAA
|
Metal
|
|
6
|
BBBB
|
Blue
|
· What is Difference between Delete and Truncate
· Performance Tuning in SSIS
· Explain Flow draw of ForEachLoop Container with Example
· Difference between Function and SP
· Cluster and Non Cluster Indexes
· Write a Query for Below I/P and O/P
I/P
|
Year
|
Month
|
Sales
|
|
2012
|
Jan
|
10000
|
|
2012
|
Feb
|
20000
|
|
Year
|
Jan
|
Feb
|
|
2012
|
10000
|
20000
|
· What is O/P
Select 1
Union all
Select 1
· How to Create Cube (Clearly Explain)
No comments:
Post a Comment