hoyt:

Go with the first statement: you won't be able to plug functions in at the last moment. When you prepare the statement, the SQL server compiles the statement with the expectation that you're going to provide the actual values to stick into the table, *not* instructions on how to compute the value to stick into the table. Similarly, you can't use table names or join columns as parameters either.

...roboticus

When your only tool is a hammer, all problems look like your thumb.