what is curser.
Answers were Sorted based on User's Feedback
Cursor is a database object used by applications to
manipulate data in a set on a row-by-row basis.
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / guest
Cursor helps to update, add, select, remove on a row by row
basis on a table
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / pervej munjal
Cursor plays there row quite nicely but although there are
some disadvantage of Cursor .
Because we know cursor doing roundtrip it will make network
line busy and also make time consuming methods. First of
all select query gernate output and after that cursor goes
one by one so roundtrip happen.Another disadvange of cursor
are ther are too costly because they require lot of
resources and temporary storage so network is quite busy.
Site of Dot net and sql server
("http://www.dotnetquestion.info")
<a href="http://www.dotnetquestion.info">link</a>
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vijay
The set of rows is returned by SELECT statementb by using
WHERE clause or not. In our application can not work
EFFICIENTLY to this result set. If we want to
access/process the entire block or row or fields or it
different kind of property, we need the mechanism. This
mechanism is called CURSOR.
Is This Answer Correct ? | 1 Yes | 0 No |
SQL SERVER 2000,
Cursor is a database object used by applications to
manipulate data in a set on a row-by-row basis.
Cursor helps to update, add, select, remove on a row by row
basis on a table.
A cursor is a mechanism by which you can assign a name to
a "select statement" and manipulate the information within
that SQL statement.
We've categorized cursors into the following topics:
1.Declare a Cursor
2.OPEN Statement
3.FETCH Statement
4.CLOSE Statement
5.Cursor Attributes (%FOUND, %NOTFOUND, etc)
6.SELECT FOR UPDATE Statement
7.WHERE CURRENT OF Statement
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / pawan mothsra
Cursor is a entity in database which is used to fetch data
from database by application by row by row.
Cursor is mainly used for calculation on data on basis of
row by row and you can do transection on another table with
this data row by row basis.
You can use cursor by :-
1.Declare a Cursor
2.OPEN Cursor
3.FETCH and FETCH NEXT Statement
4.CLOSE Cursor
5. Deallocate Cursor
You can take help for .Net, C#, Sql Server, VB.Net Articles
and Interview Questions
("http://www.developerchoice.com")
<a href="http://www.developerchoice.com">DeveloperChoice</a>
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nisha
Cursor is a programming device that allows the SELECT to
find a set of rows but return them one at a time. Cursor
should be used because the host language can deal with only
one row at a time.
you can get unlimited interview questions on:
http://www.interviewhelper.org
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sandeep
Cursor is a database object even it is treated like a data
type. It is generally used for fast and resource efficient
programming. Cursor wont fetch all datas resulted from a
select statement. Only one row at a time. this speeds up
the population of the data. In select statement all datas
shud be fetched to the client machine. Few drawbacks are
there with cursor but in some cases it works well.
Is This Answer Correct ? | 0 Yes | 0 No |
Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY
What is sql injection and why is it a problem? : sql server security
Define Unique Key?
Write a program using SQL queries to find a unique entry in a table.
Difference between aggregate functions of sql?
what is the basic diffrence betn a col declared in char(1) and in varchar(1)
What is public role in sql server?
How do you connect 100 files as a flat file sources in one package of SSIS?
What is a db view?
When do you think a developer should use sql server-based cursors?
How to enter comments in transact-sql statements?
Tell me what is log shipping?