Toad Data Modeler

Posted on June 8, 2018June 8, 2018 by jrblack 2 Comments

At work our primary web application is supported or driven by a database that is not relational, has lots of redundant data, some tables don’t have Keys, there are not Foreign Keys or indexes. For those DBA’s that found this article, it would be a nightmare. So, with the database concerns and other architecture and […]... Read More

MERGE command in SQL

Posted on February 6, 2015March 2, 2018 by Jim Leave a comment

I just recently started using the MERGE command in SQL. You would use this instead of a IF, Then, Else statement. It doesn’t make sense to use this in place of If, Then, Else all the time, but in certain circumstances. My example is repetition in checking, then inserting or updating data, across Development, Stage […]... Read More

Jim Black's Blog

Code | Family | Photography | Tech Stuff

SQL

Toad Data Modeler

MERGE command in SQL