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
You want to use a perspective in an mdx query. How do you select the perspective?
What is the need for group functions in sql?
How check triggers in sql server?
How to find the version of sql server? : sql server database administration
Why use identity in sql server?
What is 2nf normalization?
Explain what is sql server english query?
What is a data source file?
How to join two tables in a single query in ms sql server?
Explain something about security and SQL Azure?
How to use order by with union operators in ms sql server?
What is normalization of database?
what is denormalization and when would you go for it? : Sql server database administration
What is data source view or dsv? : sql server analysis services, ssas
Explain how dts is used to extract, transform and consolidate data?
