4 ms·
You build your SQL statement using named parameters for the values you're going to pass in, and you use your database's client API to create a command and bind
by DougWebb 10y ago
You build your SQL statement using named parameters for the values you're going to pass in, and you use your database's client API to create a command and bind parameter values to it. Then you ask the API to execute the command.
The binding step accepts values in your language's native data types, and handles conversions to the database's data types for you in a safe manner.
- eddieh 10y agoGotcha. I didn't know what this was called. Basically it is what I meant, but a good portion of deployed code doesn't use this from my experience. Personally I'd use an ORM, but that's just me.