Hello friends, I am writing this after long time. Hope you are doing well. Lastly we have written on Extension
Author: Bhavin Pokiya
STUFF and CONCAT in SQL
STUFF and CONCAT in SQL Hello friends, We have already explained you regarding RANK(), DENSE_RANK(), ROW_NUMBER() , Aggregate functions in
Happy New Year 2016 Technothirsties
Hello Friends, New Year 2016 is just evening away. Hope your last year was just fab one and hoping that
UNIQUEIDENTIFIER in SQL Server
Hello friends, UNIQUEIDENTIFIER is GUID(Globally Unique Identifier), which is unique all over the world. UNIQUEIDENTIFIER data type stores 16 bytes

OUTPUT Clause in SQL Server
Hello friends, We have already explain regarding IIF() in SQL Server,Right Join in SQL Server,left join in SQL, Self Join

Constraints in SQL Server
Hello friends, We have already explain regarding IIF() in SQL Server,Right Join in SQL Server,left join in SQL, Self Join in
IIF() in SQL Server
Hello friends, We have already explain regarding Right Join in SQL Server,left join in SQL,Self Join in SQL Server, RANK(), DENSE_RANK(), ROW_NUMBER() and Aggregate functions

DENSE_RANK in SQL
Hello friends, When you want to apply rank to any column without storing it in table. You can use DENSE_RANK
ROW_NUMBER in SQL SERVER
Hello friends, here comes new post about ROW_NUMBER in SQL SERVER . It is easy to use in sql. I am explaining
FULL JOIN in SQL
Hello Folks, I came to know one interesting question about sql query. Question:- How to select all records which are
Grid Sorting navigate to Onbeforeunload Event
Hello Folks, my friend came to me with one issue like he has given window.onbeforeunload event to warn the user
Sorting DataList in asp.net
Hello Folks, I was wondered while searching for content that how to do sorting in datalist, but didn’t get any