Saturday, October 20, 2012

most simple example to understand common table expression in sql

Just declaration of a temporary table with single column 
declare @temp1 table
 (
   id int
 )

insert statement to insert one row in temporary table @temp1

 insert into @temp1 select 1
 common table expression example to recursively increase the column Id. i think this is the most simple example of looping or recursion to print 1 to 10 with out printing each statement individually .... :)








Here is code of common table expression in sql  
;with cte As
   (
     select id from @temp1
     union all
     select id+1 from cte where id<10 br="br">   )
   select * from cte
sql fiddle for this post can be find here sqlfiddle link 

No comments:

Post a Comment