SQL Parameters
There are 2 entries for the tag
SQL Parameters
I've started investigating the SQL CLR and decided as my first article to tie in a bit to my article on using SQL parameters in ad hoc queries. This time I'm touching on an advanced topic of sql parameters - how to pass an array as a parameter. This takes advantage of the performance benefit you get from parameters because the plan can be cached for queries that use dynamic IN statements.http://www.codeproject.com/cs/database/TableValuedFnsAsArrays.aspNext, I plan on writing a series of articles on the SQL CLR discussing the following topics:CLR SecurityCLR Performance/StabilityCLR vs T-SQLCLR Best PracticesI've almost finished the first article on...
As I look around the net at different articles and tutorials I'm surprised at how many use Dynamic SQL for samples. Even after the many warnings about SQL injection attacks. But there are other issues besides security. One of which is performance - dynamic SQL performs very poorly when not used properly. So I decided to write an article pointing out how poorly dynamic SQL can be if improperly used. I hope it will convince some to change how they write their client SQL code. Here's the link:http://www.codeproject.com/cs/database/ParameterizingAdHocSQL.aspI might even write another article that expands on this idea to put...