Why we use comments in C# code

Comments in coding plays a vital role when we work in a team or individual. Now we will get to know why to use comments while coding and how its help us. Now We will discuss about the benefits of comments in C# Normally, when we were were fresher in IT industry, completing the task given to us by our seniors or deeds which we used to set to do in particular day or duration. So during the phase when we were coding the steps and methods output we and God know, but after some weeks or month that codes … Click here to continue…..

Top Interviews Question and Answer

1. What is your salary expectation? A nasty question, do not give the salary number to them exactly as every company have its own structure of salary. Telling your salary number may lead to loss of the interview.  If you are fresher then instead, say something like, That’s a tough question. Can you tell me the range for this position? In most cases, the interviewer, taken off guard, will tell you. If not, say that it can depend on the details of the job. Then give a wide range.If you guys are experienced then 25% to 35% increment is ideal, … Click here to continue…..

Sql Server Interview Questions and Answers

1) SQL Server query to split the Field into 2 Column. This query the developer can use when the name consists of numeric value like Ram1, Ram2

Note – First 3 Character will be in First Column and the Last One in another Column 2) SQL Server query to returns the index of First numeric in the column

Note – The SQL Server (Transact-SQL) PATINDEX functions returns the location of a pattern in a string. The search is not case-sensitive. 3) SQL server query to remove special characters from a string value. Here all characters except 0-9, a-z … Click here to continue…..

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…..