Sometime we need to create Default values for columns after creating a tables, so as per need I am sharing a script to add Default to existing column on table....

...

Queue data structure work First in First out basis (FIFO). Its means that the first inserted item will come out first ...

In this post I am going to explain TakeWhile Operator in details. TakeWhile is one of partitioning operator available in Linq. It will take sequence until condition becomes false. Here is the example for that. using System; using System.Collections....

In this post I am going to explain TakeWhile Operator in details. TakeWhile is one of partitioning operator available in Linq. It will take sequence until condition becomes false. Here is the example for that. using System; using System.Collections....

I have been playing around linq and I have found great method call SkipWhile method.  SkipWhile methods skips particular element which matches condition in predicate this can be use full in condition where we need to skip elements on particular con...

I have been playing around linq and I have found great method call SkipWhile method.  SkipWhile methods skips particular element which matches condition in predicate this can be use full in condition where we need to skip elements on particular con...

Recently I am surfing on net I found useful post for LINQ there is a Zip Operator is introduce in LINQ thread two list together eg. [code] string[] codes = { "CAD","HRK","ILS", "JOD", "LTL"}; string[] states = { " Canadian Dollar", "Cr...

Recently I am surfing on net I found useful post for LINQ there is a Zip Operator is introduce in LINQ thread two list together eg. [code] string[] codes = { "CAD","HRK","ILS", "JOD", "LTL"}; string[] states = { " Canadian Dollar", "Cr...

Today i studied an interesting thing related to GO statment See in the following queries executed .***The batch preceding GO will execute the specified number of times***. create table test( id int not null identity (1, 1) primary key) g...