All articles: General SQL

Checkout our self-help content, created by our top Experts!
All articles General SQL
SQL Server sysjobhistory – Querychat
Job tasks run automatically as requests when the SQL Server Agent Jobs are started once or repeatedly according to the schedule with the specified time or date. The SQL Server history log of all jobs are maintained and stored in a log table in the msdb database named SYSJOBHISTORY table....
How to call stored procedure in Java – Querychat
In this article, we will discover what are stored procedures, what they can be used for, how we can call them and also we will see the examples of calling a stored procedure.  What is are stored procedures in Java A stored procedure is a set of SQL commands that...
SQL Hosting: Cheap Database Hosting or Free Database Hosting? – Querychat
In this article, we will check what SQL Hosting is and show how Cheap Hosting and Free Hosting are in regards to database storage. When working with a steadily growing website and having to save important data, it is necessary to have the best SQL hosting plan. There are free...
Documenting SQL Server Database Using Extended Properties – Querychat
SQL Server Extended Properties is a feature that allows us to store information about database objects. Using this feature to document our database can be valuable. This article demonstrates how to create, view, update and drop an extended property. The feature is introduced in SQL Server 2000. Before that, it...
Handling SQL1224N .. SQLSTATE 55032 Errors in db2 – Querychat
In this article, we will check on the common errors generated on the SQL 1224N … SQLSTATE 55032 statement, main issues, and possible fixes. The SQL 1224N … SQLSTATE 55032 error statement is generated in multiple types of errors, including the following:         Database Disconnect or instance...
Handling the ORA-00900 to ORA-00910 in SQL Server – Querychat
In this article, we will check on how the ORA-00900 has generated and its possible fixes. ORA-00900 error The ORA-00900 error implies that the SQL statement used is not valid or accepted in SQL. Oracle states that this error occurs when the Procedural option installation is not found (may mean...
SQL Server: Handle suspected database in systemdatabase – Querychat
A suspected database can occur for various reasons, for example, because the log file is corrupted, damaged, or lost, or a suspect status can be caused by insufficient space when restoring the database. To overcome this, there are various ways depending on the conditions. In this article, we will learn...
SQL Server connections – Querychat
SQL Server provides several features that can be used when we need to configure and show the MSSQL active connections currently to the existing databases. The easiest way can be through a feature in the SQL Server configuration manager and SSMS Activity Monitor. This article provides information step-by-step on how...
SQL Server ANSI Nulls And Quoted Identifier- Querychat
This article talks about the ANSI_NULLS and QUOTED_IDENTIFIER feature in SQL Server which is supported by SQL Server 2008 and later. We will see what these features do and how to use them. ANSI_NULLS  The ANSI_NULLS feature on SQL Server specifies how the equal to (=) and not equal to...
Sending email from SQL Server – Querychat
Why can we need the SQL Server send emails function? In this article we will learn why can we need to send email from SQL Server and also we will look at the examples of how to configure the SQL Server to send emails. Why can we need the SQL...
1 2 5 6