•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 427,025 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,540 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 7231 | Replies: 3
 |
•
•
Join Date: Aug 2006
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Accesing tables rows in Stored procedure without using cursors 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.
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.
•
•
Join Date: Aug 2006
Posts: 7
Reputation:
Rep Power: 0
Solved Threads: 1
Newbie Poster
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
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
•
•
Join Date: Aug 2006
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
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.
•
•
Join Date: Oct 2005
Location: Manchester, UK
Posts: 482
Reputation:
Rep Power: 3
Solved Threads: 33
Posting Pro in Training
•
•
•
•
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
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- PHP MySQL 5.0 stored procedure (PHP)
- How to connect a SQL stored procedure to a windows application? (VB.NET)
- Help with a stored procedure (MS SQL)
- Help with Stored Procedure (MS SQL)
- how do I run a "disconnected" stored procedure (MS SQL)
- Stored procedure call with ADO (C)
Other Threads in the MS SQL Forum
- Previous Thread: Drop User In Mssql
- Next Thread: Modal Function
