I have a 3rd party app that I suspect is behaving badly (actually, I'm about 99.9% sure it is). When I save changes to the database, it executes what should be (as near as I can tell) about 20 SQL ...

I have a report that goes and does a sort of field validation/quality assurance check.<BR><BR>Basically it runs a bunch of sub queries and shows a summary report.<BR><BR>If something is not as it ...

Over the page is a simple trigger implemented in Microsoft's SQL Server T-SQL language. The principles are identical for other enterprise databases though the syntax will vary. In this example, we ...