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
- 26296 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
How many types of database relationship in sql server?
Can we add our custom code in ssis?
What is cte (common table expression)?
Is null vs coalesce?
What is instead of trigger sql server?
List out what other servers you can use with ssrs?
Which joins are sql server default?
Can we return Data from 4(more than 1) tables in stored procedure?
What is bcp? When does it used?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
what is hash nonclustered index
Which rendering formats are affected by the pagesize properties?
What is the use of custom fields in report?
Should you normalize audio?
What is primary key, unique key, and foreign key?
