SQLServerCentral Article

Manage Your Business Rules in T-SQL Query

  • Article

Motivation At some point in the carrer, we have come across the problem of hard-coded values in SELECT or WHERE clauses.  And we all agree that these hardcoded values must be parametrised. This bad habit usually backfires when we need to troubleshoot a query. These hardcoded values are usually a business role baked in the […]

4 (1)


9,177 reads


T-SQL Tuesday #155 –The Dynamic Code Invitation


Apologies for the late invitation. A minor snafu has me hosting again. This is...

Daily Coping 6 Oct 2022


Today’s coping tip is to remind yourself that you are enough just as you...

What you can do is based on more than your direct permissions.


What you have access to is not just what you have direct permissions to....

Read the latest Blogs


Any reason to use AWS WAF over Cloudflare?

By obalikawa

I'm primarily using Cloudflare for security. I was wondering if AWS WAF is any...

OP identification

By kaj

In lengthy discussions and in developing trial and error scenarios I sometimes find it...

Windows SQL Server 2012 on Raspberry Pi

By kinropags

I am wondering whether or not there is a way to get Windows SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers