Sql Update Snippets

13 May, 2013   

You can also run this an anonymous SQL Block

05 October, 2016   

This code accumulates 100 units of part number 9999 from various storage bins

19 December, 2012   

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

21 January, 2012   

PL/SQL code example for Explicit Cursors

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

18 January, 2012   

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

28 June, 2014   

Starting in Oracle 9i, you can use the case statement within an SQL statement. It has the functionality of an IF-THEN-ELSE statement.

05 May, 2012   

ASP code example with Sql Statement

PHP code example to get All-Time Number of MySQL Queries

16 February, 2013   

Binds a php variable to an SQL statement using the bindParam() method

This function builds an HTML select list from from data retrieved from a mySQL table.

05 September, 2011   

This class is for simplifying and accelerating working with SQL, using this class is very simple; there is a sample below for this class, which I hope is useful.

18 June, 2012   

An example of Stored PL/SQL blocks

24 July, 2013   

An example of how to use the mysql_real_escape_string

The mysql_fetch_assoc "converts" a row from a table into an associative array. The mysql_insert_array "converts" an associative array into a row in a table.

31 July, 2012   

Boiler Plate for T-Sql Error handling

13 November, 2011   

Boiler Plate for T-Sql Error handling