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 two tables have the same primary key?
Explain the various types of concurrency problem?
Describe in brief databases and sql server databases architecture.
Do you know how to send email from database?
what is a self join? : Sql server database administration
What are date and time data types in ms sql server?
What is query parameter in ssrs?
Write a SQL query to delete a table?
What is openxml in sql server?
when you create a database how is it stored? : Sql server database administration
What is cached report?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Can select statements be used on views in ms sql server?
How do I start sql server 2016?
What do you understand by replication in sql server?