Reading Time: 4 minutesIt is very easy to write a DELETE statement with a JOIN. In this very brief tutorial, we’ll walk through how it’s done. We’ll go over just these two topics: Write it as a SELECT statement first Convert your query to a DELETE statement Everything in this tutorial can also Continue Reading
Default Values in Stored Procedure Parameters: Do you know this rule?
Reading Time: 4 minutesIt is very easy to set up a default value for an input parameter in a stored procedure. When we establish a default value for an input parameter, it becomes optional to provide a value for that parameter when calling the procedure. In that event, the value used for the Continue Reading