Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vijay
The set of rows is returned by SELECT statementb by using
WHERE clause or not. In our application can not work
EFFICIENTLY to this result set. If we want to
access/process the entire block or row or fields or it
different kind of property, we need the mechanism. This
mechanism is called CURSOR.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differentiate between a local and a global temporary table?
Do you know how to send email from database?
How to delete existing rows in a table?
What is RMS migrations?
what are the important architecture components of SSRS?
Explain foreign key in sql server?
What is transaction server isolation?
How to create an multi-statement table-valued function?
How to list all schemas in a database?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What is standby servers? Explain types of standby servers.
What is the difference between system objects and user objects?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is best institute to Learn DotNET And SQL in chennai?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
