Tuesday 25 June 2013

Use of ;With in Sql Server 2008




;With Detail (Datefrom,DateTo,ID)
AS (
select Date_From,Date_To,StudentId from TestTable
   )
select top 30 * from Detail

No comments:

Post a Comment

C# LINQ Joins With SQL

There are  Different Types of SQL Joins  which are used to query data from more than one database tables. In this article, you will learn a...