Interested to Buy Any Domain ? << Click Here >> for more details...
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
can an automatic recovery be initiated by a user? : Sql server administration
What is data block and how to define data block size?
How can I tell if sql server is 32 or 64 bit?
What is the difference between ddl,dml and dcl commands?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
What is sub query and its properties?
What is BCNF? How is it better than 2NF & 3NF?
How many types of stored procedures are there in sql server?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
What is the use of =,==,=== operators?
What is sql server english query?
What is the synonym of join?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is a View ? Can we insert, Update and delete a view?
What is update locks?
