Bulk fetch data using storeprocedure

Using Cursors How to bulk fetch data

Page 1 of 1

3 Replies - 6719 Views - Last Post: 08 April 2009 - 09:12 AM Rate Topic: -----

#1 gurpreetwalia  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 07-April 09

Bulk fetch data using storeprocedure

Post icon  Posted 08 April 2009 - 12:28 AM

create procedure sp_fetch
as
begin
select * from tablename
end
go
Is This A Good Question/Topic? 0
  • +

Replies To: Bulk fetch data using storeprocedure

#2 gurpreetwalia  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 07-April 09

Re: Bulk fetch data using storeprocedure

Posted 08 April 2009 - 12:38 AM

I m firing a querry which executes in app. 20 minutes

how can i get the resultset in shortest time

Thanks in advance.
Was This Post Helpful? 0
  • +
  • -

#3 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1619
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: Bulk fetch data using storeprocedure

Posted 08 April 2009 - 08:33 AM

[rules][/rules]
Was This Post Helpful? 0
  • +
  • -

#4 Jayman  Icon User is offline

  • Student of Life
  • member icon

Reputation: 415
  • View blog
  • Posts: 9,532
  • Joined: 26-December 05

Re: Bulk fetch data using storeprocedure

Posted 08 April 2009 - 09:12 AM

Do you have a question relating to the stored procedure you posted?
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1