DotNetShoutout - Dynamic SQL for Optional Parameters

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

6
Shouts

Shout it

Dynamic SQL for Optional Parameters

published 515 days, 3 hours, 22 minutes ago posted by

dhara 518 days, 4 hours, 27 minutes ago

I often see screens or reports that take multiple parameters. Each of those parameters is optional. The code SQL behind those reports often looks like this SELECT COUNT(*) AS Orders SUM(TotalDue) as TotalDue FROM Sales.SalesOrderHeader SOH WHERE (CustomerID...

category: Data | clicked: 15 | | source: beyondrelational.com | show counter code

tags: SQL Server, TSQL

Border color:

Shout it Backcolor:

Shout it Forecolor:

Count Backcolor:

Count Forecolor:

Preview

DotNetShoutout