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)?
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 multi-statement table-value user-defined function?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
Explain what are commit and rollback in sql?
System variable and temporary variables
What are the acid properties?
How to get the query of a table in sql server?
What are the steps to process a single select statement?
where can you add custom error messages to sql server? : Sql server administration
What are the methods used to protect against sql injection attack?
Differentiate between ms sql server reporting services vs crystal reports?
What are the key configuration files for sql server reporting services ?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What the different topologies in which replication can be configured?
Give a example to search fr a string in all stored procedure in sql server.
What is a filestream?