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
- 26259 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
Write down the syntax and an example for create, rename and delete index?
What is TDS(Tabular Data Stream) Gateway?
How to loop through result set objects using mssql_fetch_array()?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What do you understand by SQL*Net?
What is a trigger what are the advantages of trigger?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What is the difference between update lock and exclusive lock?
What is service broker?
What is report rendering ?
Can a function call a stored procedure in sql server?
What is transact-sql language?
Explain tablesample?
How many columns can exist together per table?
Why use cursor in sql server?
