|
|
-
|
|
Though not new in the Oracle, DB2, PostgreSQL and many other RDBMS jargon but first time in Sql Server arena is a new friend, Sequence.
So what is a sequence?
It generates sequence of numbers just like an identity column in Sql tables. But the advantage of sequence numbers is that the sequence num......
|
|
-
|
|
In Denali (SQL Server 2012), the order by clause has been enriched by the addition of two clauses
a)Offset
b)Fetch First or Fetch Next
Offset
This keyword is use to skip the number of rows before retrieving the rows for the projection. What the statement implies is that, suppose we have 100 reco......
|
|
-
|
|
The With Result Sets feature of Denali allow us to change the column names and data types of the result set that a stored procedure returns.
Before going to explore that,let us observe how in earlier versions of Sql Server (pre-Denali), we used to get the values from an executing stored procedure.
......
|
|
-
|
|
A new addition to Sql Server 2011(Denali) is the Throw statement. It is used in conjunction with the Try...Catch block and is used to notify the occurrence of runtime exception. When an exception is thrown, the program looks for the catch statement that handles this exception. By using this statemen......
|
|
-
|
|
If we use Asp.net Web Application (File -> New-> Project-> Asp.net Web Application) , we can add Global.asax as well as Global.asax.cs file.</p>
However, if we use Asp.net Web site (File->New->Website->Asp.net Website), it is not the case. By default we will have Global.asax file only and not the......
|
|
-
|
|
I have been working with JQuery since the last few days and found it to be very handy.So I thought of sharing the stuffs that I am learing/implementing everyday in the project
In this article we will look into how to work with Radio Buttons and JQuery
N.B.~ We are using JQuery1.6.1 version
Inpu......
|
|
-
|
|
Today I got a requirement of converting a Html file to a .net DataTable. Searching in the net though yield some solution, but I was looking for a library if it is available. So I found Html Agility Pack (HAP).
It is a .net library written in C# that basically parses the Html files.
Let us hav......
|
|
-
|
|
In our recent project, we have encountered some situations regarding the data table for which there was no inbuilt extension methods. Henceforth, we wrote our own and I am presenting those here.
List of DataTable Extension methods presented here
Subtract
Multiply
Divide
Average
GetDat......
|
|
-
|
|
Introduction
We all know what a switch case is henceforth there is no need for further explanation of that.
But the current one present in C# does lack certain features (at least according to me) and I am going to list them down
Case 1: Multiple case statement problem
Consider the below
......
|
|
-
|
|
We know that the factorial of a non-negative integer n, denoted by n! is the product of all positive integers less than or equal to n.
E.g. Factorial of 3 is 3*2*1 =6
That means that let’s start with the initial number and keep on decrementing it until it reaches 1.
So we can identify two t......
|
|