1. Write a query for merging two columns into one column
on conditional bases(i.e. I want to select Employee Name from
any of the column FullName or FirstName whichever is not null).
Ans.
To query from two columns conditionally we need to use CASE operator that is provided by SQL Server. Following is the query which depicts how to retrieve conditional value into one column.
1SELECT
Name= CASE
...
1. What is Windows Azure?
Ans. (First Answer)Windows Azure is Microsoft Cloud Computing Operating System. Someone needs to worry about the hardware requirement, network requirement and the correct Operating System and much other stuff when he starts designing an application. Windows Azure will help the developer to get rid of these things and let him concentrate on main area which is nothing but automation and business needs.
(Second Answer)Windows Azure is a …
1. What’s relationship between JavaScript and ECMAScript?
Ans. ECMAScript is yet another name for JavaScript (other names include LiveScript). The current JavaScript that you see supported in browsers is ECMAScript revision 3.
2. Which types javascript supports?
Ans. Number, String, Boolean, Function, Object, Null, Undefined.
3. How do you convert numbers between different bases in JavaScript?
Ans. Use the parseInt() function, that takes a string as the first parameter, and the base as …
What is Entity Framework?
Entity Framework is an additional layer between application and database that enables the developers to program against the conceptual application model instead of programming directly against the relational storage schema.
Will there be any issues adding a table without primary keys to a data model?
Every entity must have a key, even in the case where the entity maps to a view. When you use the Entity Designer to …