Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the particular row in table?(means suppose one
table contain 10 rows , in these 10 rows how to find the
particular row(example in 10 rows i want 5 row how)?
- 16 Answers
- 25810 Views
- Accenture, IBM, Marlabs, I also Faced
- E-Mail Answers
Answer Posted / uma
this is uma sorry the above is wrong.
pls the is the correct answer ,i have this answer
declare cursor on table ,after that open the cusor and
using "fetch" keyword we retrive any row ,and we have
remove the cursor explictly because it is stored in the
memory pls use dellocate keyword
declare cursou_emp2 insensitive scroll cursor for select *
from empdetails [for{readonly}]
open cursou_emp2
fetch absolute 15 from cursou_emp2
deallocate cursou_emp2
it will display 15th row, if u wnt any row u chnage instead
of 15
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is data modification?
Explain linked server in sql?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is read uncmmited?
How can change procedure in sql server?
What are the default system databases in sql server 2000?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
How do you delete a trigger?
What are the advantages of mirroring?
What do you understand by SQL*Net?
How to provide default values to stored procedure parameters?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
How to convert a table data in XML format in sql server?
What does truncate do?
What is transaction server isolation?
