SQL – Cursors

IntroductionIn a relational database, operations are carried out on a complete set of rows in a table. The SELECT statement returns all the rows that satisfy the condition in the WHERE clause of the statement. This complete set of rows that the SELECT statement returns is called a ResultSet.Some applications cannot work effectively with the [...]

Read Full Post »

ASP.NET – Server.Transfer v/s Server.Execute

Introduction
Difference between Server.Transfer and Server.Execute.

Server.Transfer v/s Server.Execute

Both Server.Transfer and Server.Execute were introduced in Classic ASP 3.0 (and still work in ASP.NET).
When Server.Execute is used, a URL is passed to it as a parameter, and the control moves to this new page. Execution of code happens on the new page. Once code execution gets over, the [...]

Read Full Post »

ASP.NET – Server.Transfer v/s Response.Redirect

Introduction
This article tell you the difference between Server.Transfer and Response.Redirect.

Server.Transfer v/s Response.Redirect
Both “Server” and “Response” are objects of ASP.NET. Server.Transfer and Response.Redirect both are used to transfer a user from one page to another page. Both are used for the same purpose but still there are some differences are there between both that are as [...]

Read Full Post »

SQL – Using "UNION ALL" to Convert Horizontal Data to Vertical Data

Introduction
Hi, today I am writing a trick which I found while solving my friends problem in SQL. May be you people already aware with this trick but it’s new for me, so I am sharing it with you. Yesterday my friend asked me a problem in SQL, he wants to convert the horizontal data to [...]

Read Full Post »

SQL – Truncate and Delete

Introduction
Hi to all, here I am with a new article; topic of this article is “Difference between Truncate and Delete”.

Truncate an Delete both are used to delete data from the table. These both the command will only delete the data of the specified table, they cannot remove the whole table data along with its structure. [...]

Read Full Post »

.NET – Short interview Questions

Introduction
This article contains the short answer interview questions related to .NET, Mostly these questions are asked in the interviews so take a look of these, I am sure it will definitely help you.

Questions

Q1. Explain the differences between Server-side and Client-side code?
Ans. Server side code will execute at server end (where the website is hosted) and [...]

Read Full Post »

SQL – Derived Tables

Introduction
With SQL Server you have the ability to create derived tables on the fly and then use these derived tables within your query. In very basic terms, a derived table is a virtual table that’s calculated on the fly from a select statement.
In concept this is similar to creating a temporary table and then using [...]

Read Full Post »