Choose function in SQL Server is used to get the item at the specified index from the list of available values. The index position starts with 1.
UnPivot is used to convert columns into rows. Continue reading
The Lead and Lag functions returns subsequent row for the Lead() while previous row for the Lag function. Continue reading
Rank() and DENSE_RANK() functions are used to return the RANK starting from 1 based on the ordering clause. Continue reading
In order to check the blocked queries in SQL server, we can make use of DBCC OpenTran command which will result in details of the transaction which has blocked the queries. Continue reading
I have been biting my nails out to figure out the problem of 404 error code for jquery in ASP.NET web form. Continue reading
We generally have resultset of our select statements. Some times we want to perform any logic on the each row of the resultset. Continue reading