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
- 23391 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
Who developed sql server?
what is database replicaion? : Sql server database administration
You want to implement the many-to-many relationship while designing tables. How would you do it?
Do you know what are different types of replication in sql server?
What is data modeling and Reterminal integrity?
Explain the xml support sql server extends?
What is the use of keyword with encryption. Create a store procedure with encryption?
Why do we use stored procedures in sql server?
Tell me can we use custom code in ssrs?
Define left outer join?
How to download and install microsoft .net framework version 2.0?
How to create a simple user defined function in ms sql server?
What is data compression?
Why variables called the most powerful component of ssis?
Explain different types of locks in sql server.
