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

What is a “locale”?

A locale is a description of certain conventions your program might be expected to follow under certain circumstances. It’s mostly helpful to internationalize your program. If you were going to print an amount of money, would you always use a dollar sign? Not if your program was going to run in the United Kingdom; there, you’d use a pound sign. In some countries, the currency symbol goes before the number; in some, it goes after. Where does the sign go for a negative number? How about the decimal point? A number that would be printed 1,234.56 in the United States … Click here to continue…..