Answer Posted / kuttikrishnan kodoth
if we ant to retrive data from a database table having
duplicate entries which violates primarykey rule
we can handle this case using cursor, it by declaring a
cursor which would check the
records during retreival one by one and remove rows which
have duplicate values. there are many types of cursors to
fetch data in diffrent order like fetch first,fetch
last ,fetct prior,fetch next,fetch abslute n,fetch relative
n
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the lambda triggers?
Difference between DELETE and TRUNCATE?
What are the steps to process a single select statement?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
How to copy data from one table to another table?
How do I delete a sql server database?
What is an execution plan? When would you use it?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is mapping schema?
Can you roll back the ddl statement in a trigger?
What is the library index called?
How to create user messages with print statements in ms sql server?
How can I tell if sql server is 32 or 64 bit?
What is partition index in sql server?
