sp fetch function sql server RSS

• • Reply
  

  -_-

  Member

  375 Points

  1033 Posts

  sp fetch function sql server

  Feb 29, 2012 09:19 AM|LINK

  i would like to ask how to select data 1 by 1 to the parameter.

  if the temp table has 10 record,

  declare @para varchar(100)

  set @para=<-- select one by one , each time one val (like for loop function to extract data )

  select * from A where id=@para

  • Edited by -_- on Feb 29, 2012 09:43 AM
  • Edited by -_- on Feb 29, 2012 09:43 AM
  • Edited by -_- on Feb 29, 2012 09:43 AM
• • Reply
  

  yrb.yogi

  Star

  14460 Points

  2402 Posts

  Re: sp fetch function sql server

  Feb 29, 2012 09:29 AM|LINK

  --temp table
  declare @tabla table
  (
  	ID int identity(1,1),Name varchar(100)
  )
  insert into @tabla
  select 'yogesh bhadauriya' union all
  select 'bhadauriya yogesh'
  
  --loop
  declare @i int
  set @i=1
  declare @count int
  select @count=COUNT(*) from @tabla
  
  --varaible to hold data
  declare @id int
  
  while @i<=@count
  begin
  	select @id=ID from @tabla where ID=@i;
  	
  	--here you will get data
  	select @id
  
  --increment
  set @i=@i+1;
  end

  Yogesh Bhadauriya
  .Net All About
  
  • Edited by yrb.yogi on Feb 29, 2012 09:43 AM
  • Marked as answer by Chen Yu - MSFT on Mar 05, 2012 08:48 AM