GitHub

How to pass a dashboard parameter to a custom SQL query in code

The following example demonstrates how to create a new dashboard parameter and pass it to a custom SQL query. In this example, the dashboard parameter is passed to the custom SQL query parameter's ...
Ars Technica

T-SQL + SSRS parameter problem

SELECT * FROM table1 WHERE fieldStatus IN (@Status) AND (CASE WHEN @Status = 'Open' AND COUNT(@Status) = 1 THEN fieldDate >= GETDATE() END) I hope that makes sense. Anyone know how to test for a multi ...
Ars Technica

[ASP.NET/SQL CE 4] A parameter is missing. [ Parameter ordinal = 1 ]

Help! This is really strange, as it seems correct to me. Code: Dim PKID As Guid = Membership.GetUser(User.Identity.Name).ProviderUserKey sqlCmd.Parameters.AddWithValue("@PKID", PKID) ...
GitHub

BezouwenR/command-for-SQL

A meta parameter - declaring a command constant ( that is not visible when prompting) Then the CL data type and and SQLCLI equivalent - Here we let SQL handle the conversion of data types under the ...
InfoWorld

How to use parameter binding in minimal APIs in ASP.NET Core

Take advantage of parameter binding in ASP.NET Core 7 to convert request data to strongly typed parameters, improving both application performance and code maintainability. Minimal APIs are a type of ...