Create Immediate Messages

By Greg No comments

In SQL, when you don’t want to change the result set, but you want to provide some messages, for example, when debugging a query in SSMS, it can be really helpful to use the PRINT statement. What you’ll start to notice though is that the print statement doesn’t always print straight away. Usually this is […]

Fantasy SQL Feature – T-SQL Tuesday

By Greg 2 comments

This month for T-SQL Tuesday, Kevin Chant has asked the question “What is your Fantasy SQL Feature?” There are a few that I would love to have, but the one that keeps popping up is having a foreign key that can reference more than one table. I know this seems like an odd request, but […]