Archives

Inner Join in SQL Server

You can use inner join to get the result of two tables that match the criteria. For example , assume that you have a Person table and a Phone Number table where every person would have 0 or more phone number associated to him and you wish to get the person records who have at least one phone number. Here’s the query on how to…

InterSystems IRIS General Error Code – 2043

In this post, you’ll learn about the General error code 2043 in InterSystems IRIS database the reason why you are receiving the error message when using the InterSystems IRIS data platform Error Code : 2043 Reason for the Error code 2043 in InterSystems IRIS DBMS Could not add new member when the Async member connected

InterSystems IRIS General Error Code – 7334

In this post, you’ll learn about the General error code 7334 in InterSystems IRIS database the reason why you are receiving the error message when using the InterSystems IRIS data platform Error Code : 7334 Reason for the Error code 7334 in InterSystems IRIS DBMS Unable to read file, Backup or Restore is in progress

InterSystems IRIS TSQL Code 3718 Could not drop index ‘%.*ls’ because the

In this post, you’ll learn about the SQL error code 3718 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform Error Code : 3718 Reason for the Error code 3718 in InterSystems IRIS DBMS Could not drop index ‘%.*ls’ because the table or clustered index entry cannot be found in the sysindexes system table.

InterSystems IRIS TSQL Code 15225 No item by the name of ‘%s’ could be fou

In this post, you’ll learn about the SQL error code 15225 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform Error Code : 15225 Reason for the Error code 15225 in InterSystems IRIS DBMS No item by the name of ‘%s’ could be found in the current database ‘%s’, given that @itemtype was input…