How To Change The Schema Of All Tables In A SQL Server Database
Below is the SQL that can be used to change the database schema of all tables in an SQL Server Database. We use it when...
Oracle JDEdwards EnterpriseOne in FireFox 20
As some may have noticed, the latest version of FireFox breaks Oracle JDEdwards EnterpriseOne. Well, we found a fix on JDEList posted by cpb (Charles...
How To Send Email Attachments Using Native Oracle JDEdwards EnterpriseOne
On his blog, Shannon Moir has a great post, "Simple JDE BSFN to send an email with an attachment", about how to send email attachments...
How To Drop All Tables In An SQL Server Database
I've been doing a lot of work with SQL Server lately and have found the following SQL that can be used to drop (delete) all...
Great iSeries SQL Reference When Working With Dates & Times
I really used this page a lot when working with SQL and dates & times. DB2 Basics: Fun With Dates and Times