Top Sql Server Interview Questions and their Answers

1)  How to create an empty table emp1 with same structure as emp?

2)  How to find the Max Salary from each department?

3) Retreive year part from the table ..

Similarly for MONTH

4) Get the difference of month of DateTime.

    Similarly for Days

5) Get all Employee details whose Joining Year is 2016.

6) Select all the Employees whose JoiningDate is JAN(1).

7) Split Date, month, Year from DateTime Here is query You can achieve this task in two ways. a) DATEPART b) Year,Mont,Day Let’s see the Query: … Click here to continue…..

Steps to Import WPF controls into MFC Application

Step 1: Create an MFC Project Open Visual studio Go to Files -> New -> Project Expand Other Project Types from Recent Templates from left panel and select Visual C++ Select MFC Application from the available projects list from Middle panel. Give a Project Name, Select the Path and Click OK – Application Wizard opens Click Next for the first screen and Select Dialog based radio button in the secomd screen (Application Type screen) Click Finish – This creates an MFC Application with Header file, Resource files and Source files Step 2: Change the default Configuration of the MFC Project to … Click here to continue…..