Pre-requisites: Microsoft SQL Server, some knowledge of SQL, and a sample database, Northwind. You can find Northwind sample databses from this webpage https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/northwind-pubs Criteria From time...
Continue reading...Backend
SQL – Concatenate Names and get totals
In this short blog post, I’ll show you how to concatenate an employee firstname and last name, then get the total orders made under that employee....
Continue reading...Don’t Delete Records. DeleteFlag instead
If you have a process which can delete records from the database, it would be best to DeleteFlag them instead. You should add a few columns...
Continue reading...Batch Insert Records
If you need to insert multiple records at the same time. Writing out those SQL insert queries can be laborious. Setting the same fields and then...
Continue reading...Create a Stored Procedure with a series of stored procedures
We’re going to cover on how to write a stored procedure with a series of stored procedures. That means running a number of stored procedures within...
Continue reading...
Recent Comments