Parameters

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)

You rated this post out of 5. Change rating

2022-10-18 (first published: )

10,725 reads

Blogs

What Does Redgate Test Data Manager Do?

By

At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...

Extracting PostgreSQL database metadata for presentation in Excel format

By

(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...

Change Notebook Spark Session Time-Out in Microsoft Fabric

By

You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...

Read the latest Blogs

Forums

blank page appears after every printed page in subreport

By stan

Hi, i'm getting a blank page after every printed page of my invoices in...

How Important archiving old data

By vsamantha35

Hi All, How important is it archiving old data ? In recent days, We...

Precuations of reducing the VLFs

By vsamantha35

Hi All, We have a database with 5TB size and has VLF near to...

Visit the forum

Question of the Day

SQL Express Agent

How can I run SQL Agent with SQL Server Express 2022?

See possible answers