I’ve recently been teaching myself MongoDB, comming from a releational database background it’s taking me time to learn how MongoDB works. This article will be the first of many where I will post my notes and how to’s from my…
Sometimes you need some protection in place on your important database tables to prvent an accidental bulk update of the table from such a query:
SET contactname = 'NewName'
To help prevent such as accident we can create a trigger(s) on the table(s)…
sql server offers us a few functions when working with time, in this article I am going to explain the functions that we can use to get date and time parts. The functions that we have are: DATEFROMPARTS SMALLDATETIMEFROMPARTS…