Sql Error Handling Snippets


18 January, 2012   

SQL GROUP BY Clause returns group of rows. An example code for SQL GROUP BY clause

06 November, 2013   

Example shows how to handle window closing events. This is a very basic event handling when you are working on a UI Application.

In order for this to work, you will need to copy mysqldump.exe and mysql.exe from the MySQL bin Program Files folder into the same directory as your executing PHP script. If you know the direct path to these for your server, you can use those instead.

PL/SQL functions returns a scalar value and PL/SQL procedures return nothing. Both can take zero or more number of parameters as input or output. The special feature about PL/SQL is that a procedure/function argument can be of input (indicating the argument is read-only), output (indicating the argument is write-only) or both (both readable and...

08 September, 2012   

SQL query to know total number of employee on each department.

08 September, 2012   

SQL query to know employees where city is null

13 May, 2013   

You can also run this an anonymous SQL Block

19 December, 2012   

How to convert a java util Date into a sql Date for use in databases.

11 July, 2013   

Help manage mysql database common task

21 January, 2012   

PL/SQL code example for Explicit Cursors

15 March, 2011   

This comes down to fixing a simple, yet annoying bug in IE’s capability of handling min-height. In essence, IE interprets height as min-height, so since IE wont implement the auto height, this snippet will fix all this for us.

07 April, 2013   

A simple example code for user login with a login form and database query

21 January, 2013   

VB code to add data using access

Below shown how to Back Up and Restore a MySQL Database

05 July, 2012   

Backup MySQL Database to SQL File with mysqldump

29 December, 2012   

How to Back Up and Restore a MySQL Database

14 May, 2012   

How to generate SYNONYMS SQL

15 November, 2012   

If one of the input values is zero, then the program will end with an error code of "1" in the job control card listing following the execution of the program. Normal output will be one line printed with A, B, C, and AREA. No specific units are stated.

18 January, 2012   

You can combine with SQL JOIN clause to show department name with count.

22 March, 2015   

Program shows copying one text file from source location to any other location (destination), plus possibility of changing its name, and also shows many language features in exception handling. This program should be run from the command prompt