by Yogesh | Jun 27, 2016 | LINQ Tutorial
Like TakeWhile, the SkipWhile query operator uses a predicate to evaluate each element in the input sequence. SkipWhile will ignore items in the input sequence until the supplied predicate returns false. using System; using System.Collections.Generic; using...
by Yogesh | Jun 27, 2016 | LINQ Tutorial
The Skip query operator will ignore the specified number of input elements from the start of the input sequence and return the remainder. The following code skips over the first three elements and returns the rest: using System; using System.Collections.Generic;...
by Yogesh | Jun 27, 2016 | SQL Server
create function ganesha(@id int) returns int as begin declare @work int select @work=avg(salary) from emp_info where id=@id; return @work; end; declare @my int select dbo.ganesha(1) b) alter function myfun(@date datetime) returns varchar(50) as begin declare @myoutput...
by Yogesh | Jun 27, 2016 | LINQ Tutorial
TakeWhile: This operator is useful when we want to iterate a long list of items. During iteration we can get list of items by using predicate function. Let’s take a example where I will generate numbers using IEnumerable range method and get items as per predicate...
by Yogesh | Jun 25, 2016 | SQL Server
–Self Join select *from emp as p where p.salary=p.gsalary –Equi Join select d.*, e.* from dept as d , emp as e where d.id=e.deptids –Inner Join select d.*, e.* from dept as d inner join emp as e on d.id=e.deptids –Outer Join –Left Outer...
