FLOWERINGPETALS.BLOGSPOT.COM

dotnetinterviewcracker.blogspot.com

Dot Net Interview Cracker - A comprehensive list of Dot Net Interview Questions: May 2014

http://dotnetinterviewcracker.blogspot.com/2014_05_01_archive.html

Net Framework - Quick Reference Guide. The Net Framework E-Book. By the .Net Interview Cracker is a very useful resource for developers and serves well as a quick reference guide. This E-Book prepares them for technical interviews in Microsoft .Net Framework. The list of topics included in the very first edition of the E-Book is as given below:. What is .NET Framework? Explain the architecture of .Net Framework. Common Language Runtime (CLR). Features of the Common Language Runtime. What is DLL Hell?

dotnetinterviewcracker.blogspot.com

Dot Net Interview Cracker - A comprehensive list of Dot Net Interview Questions: Shallow Copy Vs Deep Copy

http://dotnetinterviewcracker.blogspot.com/2012/11/shallow-copy-vs-deep-copy.html

Shallow Copy Vs Deep Copy. For instances of value types, the '=' assignment operator copies the state of the source object to the destination object. The copy is done byte-by-byte. Simple object copying by members is achievable through the method MemberwiseClone(). Inherited from System.Object. This is a protected method and the copying supplied by it is known as shallow copying (it copies the reference but not the referred object; thus the original object and its copy/clone refer to the same object).

dotnetinterviewcracker.blogspot.com

Dot Net Interview Cracker - A comprehensive list of Dot Net Interview Questions: October 2013

http://dotnetinterviewcracker.blogspot.com/2013_10_01_archive.html

ASPNET HttpHandlers – Are they really required? ASPNET HttpHandler is a process that runs in response to a request that is made to an ASP.NET Web application. Almost everything we do in an HttpHandler, can be done in a normal .aspx page. So, why do we need HttpHandlers? Are they really required? Given below is the explanation of why HttpHandlers are really required:. Handlers in ASP.NET. Console applications or Windows applications do not have handlers. We declare a class and create an object of that...

dotnetinterviewcracker.blogspot.com

Dot Net Interview Cracker - A comprehensive list of Dot Net Interview Questions: PIVOT - UNPIVOT operator

http://dotnetinterviewcracker.blogspot.com/2015/06/pivot-unpivot-operator.html

PIVOT - UNPIVOT operator. Explain PIVOT and UNPIVOT operators in SQL. PIVOT and UNPIVOT are relational operators which were introduced in SQL Server 2005. These operators allow easy transformation of table-valued expression into another table. PIVOT allows you to rotate rows into columns during the execution of an SQL Query. It performs an aggregation, and merges possible multiple rows into a single row in the output. A simple example of PIVOT operator. Suppose we have a dbo.currency rate. In continuatio...

dotnetinterviewcracker.blogspot.com

Dot Net Interview Cracker - A comprehensive list of Dot Net Interview Questions: September 2013

http://dotnetinterviewcracker.blogspot.com/2013_09_01_archive.html

Enumerate the Steps for creating a Shared Assembly. Step 1: Generate a Strong Name Key:. D: Project DLL sn -k dll.snk. The above statement will write a Kay pair to dll.snk file. Step 2: Associate the Strong Name Key with source code. Create a program to be used as DLL - First.cs. Using System.Reflection;. Return "Anuj Ranjan";. A) Save the file as First.cs in D: Project DLL First.cs. B) Compile the program to create a DLL from the Command Prompt as given below:. D: Project DLL csc /t:library First.cs.

dotnetinterviewcracker.blogspot.com

Dot Net Interview Cracker - A comprehensive list of Dot Net Interview Questions: .Net Framework - Quick Reference Guide

http://dotnetinterviewcracker.blogspot.com/2014/05/net-framework-ebook.html

Net Framework - Quick Reference Guide. The Net Framework E-Book. By the .Net Interview Cracker is a very useful resource for developers and serves well as a quick reference guide. This E-Book prepares them for technical interviews in Microsoft .Net Framework. The list of topics included in the very first edition of the E-Book is as given below:. What is .NET Framework? Explain the architecture of .Net Framework. Common Language Runtime (CLR). Features of the Common Language Runtime. What is DLL Hell?

dotnetinterviewcracker.blogspot.com

Dot Net Interview Cracker - A comprehensive list of Dot Net Interview Questions: Differentiate between Shadowing and Overriding

http://dotnetinterviewcracker.blogspot.com/2012/10/differences-between-shadowing-and.html

Differentiate between Shadowing and Overriding. 8211; This is a. By which you can provide a new implementation for the base class member without overriding the member. You can shadow a base class member in the derived class by using the keyword. The method signature, access level and return type of the shadowed member can be completely different than the base class member. 8211; This is a. The method signature, access level and return type of the hidden member has to be same as the base class member.

dotnetinterviewcracker.blogspot.com

Dot Net Interview Cracker - A comprehensive list of Dot Net Interview Questions: July 2013

http://dotnetinterviewcracker.blogspot.com/2013_07_01_archive.html

Ranking functions in SQL. Introduced with SQL Server 2005 allow us to assign a number to each row returned from a query. They allow us to rank each row in respect to others in several different ways. Ranking functions can be used only. With the SELECT and ORDER BY statements. They cannot be used directly in a WHERE or GROUP BY clause, but can be used in a CTE or derived table. The syntax for ranking functions is shown as follows:. Function name () OVER([PARTITION BY partition by list ]. FROM Sales.Cu...

dotnetinterviewcracker.blogspot.com

Dot Net Interview Cracker - A comprehensive list of Dot Net Interview Questions: Conversion of Seconds to HH:MM:SS format

http://dotnetinterviewcracker.blogspot.com/2013/10/conversion-of-seconds-to-hhmmss-format.html

Conversion of Seconds to HH:MM:SS format. Recently I faced a requirement of converting seconds to HH:MM:SS format. After some R&D, I found the following solution:. One Hour One Minute and One Second. This SQL code is applicable only for time less than 24 hours. To overcome this limitation of 24 hours, I created the following function, which has the ability to return correct time duration for large time duration in seconds:. SET ANSI NULLS ON. SET QUOTED IDENTIFIER ON. Dc time decimal(18,2). Shadowing &#8...

dotnetinterviewcracker.blogspot.com

Dot Net Interview Cracker - A comprehensive list of Dot Net Interview Questions: June 2013

http://dotnetinterviewcracker.blogspot.com/2013_06_01_archive.html

What is the maximum allowable size of a row in SQL SERVER? If a table does not contain any sparse column. Then the maximum allowable row size is 8060. However, if a table contains sparse columns. Then the maximum allowable row size is 8018. How is a column changed from sparse to nonsparse or nonsparse to sparse. The SQL SERVER Database Engine adds a new column to the table in the new storage size and format. The SQL SERVER Database Engine then removes the old column from the table schema. A sparse column...