ORACLE AND MSSQLSERVER

RAISE_APPLICATION_ERROR? The RAISE_APPLICATION_ERROR is a procedure defined by Oracle that allows the developer to raise an exception and associate an error number and message with the procedure other than just Oracle errors. Raising an Application Error...

What is the purpose of FOR UPDATE? Selecting in FOR UPDATE mode locks the result set of rows in update mode, which means that row cannot be updated or deleted until a commit or rollback is issued which will release the row(s). If you plan on updating...

CHAR datatype Char contain alphanumeric data. Length of Char datatype is between 1 and 255 characters. If you don't specify a length, a char column stores a single character by default. Char datatypes stores data in the Fixed-Length Format. Be aware,...

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...