SQL Server Developer , Mind Tree /CIT

posted Jan 20, 2017 in SQL Server by martinziller218 (100 points)
1. I have 2 tables Employee and Dept.

a. Get names of all employees who do not work for anu Dept.

b. Arrange the salaries as Emp Name, Sal, Lower Sal and the next higher

salary to this employee

c. In SP i have 3 inserts though all inserts fail SP should not fail

d. I have Gender as M and F, convert M-F and F-M

Performance tuning of queries

Performance tuning of SSIS package

Script Component In SSIS

Package Deployment
Welcome to I Can Crack, where you can ask questions and receive answers from other members of the community.

68 questions

47 answers


5,318 users