Ad:

MS SQL Discussion Thread
Unsolved
Views: 16658

Aug 30th, 2006

Accesing tables rows in Stored procedure without using cursors

Expand Post »

From last two days i am searching for the answer of this querry.
I want to know how can i access the rows of tables in stored procedures using loops(Without cursor).
We don't want to use cursor for that because of the performance issues.

Similar Threads

PHP MySQL 5.0 stored procedure in PHP
How to connect a SQL stored procedure to a windows application? in VB.NET
Help with a stored procedure in MS SQL
Help with Stored Procedure in MS SQL
how do I run a "disconnected" stored procedure in MS SQL

sarvesh jaiswar

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Aug 2006

Permalink

Sep 1st, 2006

Re: Accesing tables rows in Stored procedure without using cursors

Just to a while loop.

declare @rowcount int,
@counter int
select @rowcount = (select count(*) from table_name)

set @counter = 0
while @counter <= @rowcount
begin
select * from table_name where rowid = @counter
set @counter = @counter + 1
end

itsdavetime

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

7 posts
since Aug 2006

Permalink

Sep 4th, 2006

Re: Accesing tables rows in Stored procedure without using cursors

Click to Expand / Collapse Quote originally posted by itsdavetime ...

Just to a while loop.

declare @rowcount int,
@counter int
select @rowcount = (select count(*) from table_name)

set @counter = 0
while @counter <= @rowcount
begin
select * from table_name where rowid = @counter
set @counter = @counter + 1
end

MY REPLY:
What was rowid here. It was giving invalid column name in SQL SERVER. PLZ reply soon.

sarvesh jaiswar

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Aug 2006

Permalink

Sep 4th, 2006

Re: Accesing tables rows in Stored procedure without using cursors

Click to Expand / Collapse Quote originally posted by sarvesh jaiswar ...

MY REPLY:
What was rowid here. It was giving invalid column name in SQL SERVER. PLZ reply soon.

your auto-incrementing id field

pty

Reputation Points: 64

Solved Threads: 39

Posting Pro

Offline

530 posts
since Oct 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Drop User In Mssql

Next Thread in MS SQL Forum Timeline: Modal Function

DaniWeb Message

Cancel Changes

User Name
Password