Jim Black's Blog

Code | Family | Photography | Tech Stuff

Menu
  • LinkedIn
  • Facebook
  • Twitter

SQL

snip_20180608162434.png snip_20180608162434_thumb.png snip_20180608162238.png snip_20180608162238_thumb.png snip_20180608162132.png

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
Posted in Software Development, Tech StuffTagged Code Software SQL

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
Posted in Software DevelopmentTagged Code SQL

Recent Posts

  • Grandfather Mountain Hike
  • Front door–New Lock, Repair and Paint
  • New Washing Machine
  • New Convection Oven
  • Night-time Photography
  • Caitlin and Dance for spring 2020
  • New Patio Project
  • Daisy our new doodle
  • Covid-19 Pandemic and Working From Home
  • Winter Furniture Market in Atlanta

Categories

  • #LoveMyPhoneCamera
  • Android
  • Blogging
  • Dance
  • Family
  • Friends
  • Handyman
  • Hiking
  • Market
  • Nature
  • Photography
  • Programming
  • Software Development
  • Tech Stuff
  • Uncategorized
  • Web Stuff
  • Xamarin

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Archives

Tags

#SCCSOLO .Net Android Android Apps Animals BlogEngine.net C# Code Concert Critters Dance Photography Doodle extension Family Time Friends Furniture Market Gmail God Google Photos Home HTML Labradoodle LG Live Writer Music MVC Nature Nature Photography Patio Photography Photos Picasa Pictures Rodents Software Sports Photography Spring Break SQL Team Foundation Server TXT Video Visual Studio WebApi Xamarin Zoo
Theme: levii by Kaira.
Powered by WordPress