• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Dynamic stored procedures in C#/ASP.NET

T

TheEarthWillShake

Member
How would I go about making a dynamic stored procedure?

For example, I have a Oracle database with a table
Row1 has Dates
Row2 has Numbers


So say I want to make a select query from Jan 08 to June 08, but also also be able to do Jan 07 to Jan 08 if I want to dynamically as in it's up to the user?
 
Your stored procedure would need to take parameters. Then just pass the dates into the stored procedure, making sure to sanitize the user input first.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top