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
- 25686 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
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
List some major differences between triggers and stored procedures?
Explain use of expression builder.
How to execute multiple stored procedures at one time in sql server?
List the different types of collation sensitivities in sql server?
Is resultset an interface?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Do you know what is sql service broker?
What are the types of resultset?
what is package and it uses and how can u call a package
Explain what you mean by 3 tier architecture.
What is an identity column in insert statements?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
what is a sub-report?
What are the different SQL Server Versions you have worked on?
