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
Explain what are the different index configurations a table can have?
What is the difference between SQL notification and SQL invalidation?
What are the purposes of floor and sign functions?
How many types of database relationship in sql server?
How to convert a numeric expression from one data type to another?
How to list all user names in a database?
What is catalog views?
What are functions in the sql server?
What happens if you insert a duplicate key for the primary key column in ms sql server?
What is nolock?
What do you understand by recursive stored procedure?
How do I view a trc file?
How to create dbo table in sql server?
How to get a list of columns using the "sys.columns" view in ms sql server?
What is index fragmentation in ms sql server?
