Difference Between Cursor And Ref Cursor In this post I am trying to detail out the differences between Cursor and Ref Cursors. I am sure, this question has been asked in many interviews to many of us and it also has its own technical weightage. Lets...

PROCESS: 1 ITIL (Information Technology Infrastructure Library) Process 2 DBAMaintains Activities(Daily\weekly\Monthly) 3 DR (Disaster Recovery) Plan 4 BCP (Business continuity Plan) Plan 5 RACI (Responsible Accountable Consult Inform)Matrix 6 RCA ( Root...

Adding files or filegroups. Changing collation. The default collation is the server collation. Changing the database owner. master is owned by sa. Creating a full-text catalog or full-text index. Creating triggers on system tables in the database. Dropping...

Issue : I am able to connect to MSSQL Server Management Studio with Windows Authentication but unable to connect with SQL Server Authentication. The 'sa' login details are correct but still getting the following error message. Login failed for user 'sa'....

Error 3154 and 3013 How to fix the SQL backup Error 3154 and 3013? Today we have faced below error msg while restoring sql backup file from drive . Msg 3154, Level 16, State 4, Line 1 The backup set holds a backup of a database other than the existing...

SQL Error 2098, 8344 To understand the error you can transcribe the error message 0x2098 in a more readable. - You can use the tools: Error Code lookuphttp://www.microsoft.com/downloads/details.aspx?familyid=be596899-7bb8-4208-b7fc-09e02a13696c&displaylang=en...

SQL Error 4064 Issue Description : Each user has a default database. When you connect to computer that is running Microsoft SQL Server, and you do not specify a login database, the default database is used. However, if the default database is unavailable...

compound DML trigger rA compound DML trigger created on a table or editioning view can fire at multiple timing points. Each timing point section has its own executable part and optional exception-handling part, but all of these parts can access a common...

What is PL/SQL? Procedural Language extension to SQL It integrates procedural constructs with SQL SET SERVEROUTPUT ON This command is used to send the output from the server to the screen Lesson 1-2 Introduction & Declaring PL/SQL Identifiers SQL> SET...

The Instr function is used to find the position of a string in another string. Optionally you can provide position m to start searching for the string and the occurrence n of the string. By default m and n are 1 which means to start the search at the...