General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Kevin
>One other point - generating SQL code inside of the application really hurts the chance of reusability in other applications hitting the same database.
>By placing the code in a stored proc, the level of difficulty in exposing this as an API to multiple applications does down.
Any layered approach should minimze the hurt<g>. The ease of testing you posted elsewhere on is for me a less of an issue as dynamic environments are easier testbeds.
For me this "challenge" resulted in the following tick points:
MS-Sql in this task was not "better" as much as another thread hinted at
Using enhancements of SQL makes sense from a coding difficulty POV
coding such enhancements mean at least partial lock-in, so one good approach to minimize damage would be to isolate such usage.
While not an arguement against SP per se, the above point is a strong argument in favor of either code generation or generated SP's.
my 0.02 EUR
thomas
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only