Oracle / SQL Server / DB2 / Mckoi / MySQL Database Equivalents

Hi,

For few of our projects client requested us the application should be compatible with multiple databases viz. Oracle / SQL Server / MySQL / DB2…..

Post additional info on this which could be more useful of all of us. Thank you.

PAL

SQL Server 2008

MicroSoft SQL Server 2008 The latest version is SQL Server 2008, and it offers a large variety of new Features and functionality that will make the administration a whole lot better.Database administrator who have been using SQL Server® 2005 for any length of time will find many of the same features that they use in their day-to-day jobs, but they'll also soon discover that these familiar tools have been enhanced in SQL Server 2008. The new functionality built on the existing features goes a more [...]

Difference between DELETE, TRUNCATE, DROP in SQL

Hi, Thought of sharing, The DELETE command is used to remove rows from a table. A WHERE clause can be used only to remove some rows. If no WHERE condition is specified, all rows will be removed. After performing a DELETE operation you need to COMMIT or ROLLBACK the transaction to make the change permanent or to undo it. TRUNCATE removes all rows from a table. The operation cannot be rolled back. As such, TRUCATE is faster and doesn't use as much undo space as a DELETE. The DROP command more [...]

Test your database query skill

Hi, Below is the table showing some records, you need to create a query which has the output showing the employee name and his related lead name Table data's emp_id emp_name lead_id 1 Palaniappan 1 2 moorthy 1 3 senthil 1 4 manoj 2 5 deepa 3 The result will be emp_name lead_name Palaniappan Palaniappan moorthy Palaniappan senthil Palaniappan manoj moorthy deepa senthil Note: it is single table not more [...]

Use LIKE operator in VB .Net

  Posted By Ashok Generally in MS Access we use LIKE operator with '*' character for easy search. But when working with VB 6.0 or VB .Net coding with ADO it will not work if we use '*' character. We should replace the '*' character into '%' character. Then only it will work. But, if we use '%' character directly in MS Access, it will not display any query results even the formed query is correct. There we should use '*' character. Only in VB 6.0 or VB .Net coding with ADO, '*' character more [...]