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
how you can list all the tables in a database?
Explain transaction server consistency?
How to create view in stored procedure sql server?
Does transparent data encryption provide encryption when transmitting data across the network?
What are the grouping functions?
Write a sql query to get zero records from a table having n number of records?
What is trace flag in sql server?
What is a View ? Can we insert, Update and delete a view?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
How to define the name and server for a new dsn?
Explain the difference between delete,drop and truncate in SQL Server?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
What are clustered and non-clustered index?
What is the difference between left and right outer join?
What is page-level compression?
