CBusPASS Chapter Meeting
Thursday, March 12, 2009 from 6:30 PM to 8:30 PM (EDT)
When: Thursday, March 12th, 6:30PM - 8:30PM
Where: Battelle For Kids
Food and drinks will be provided.
Dynamic SQL Tips, Tricks, & Techniques
Speakers & Abstract
Dynamic SQL is a powerful but difficult tool to master. Jeremiah will show you techniques for creating rock solid, fast, dynamic SQL that will meet the day to day needs of your production system.
Do you have a need for search functionality within your database but are limited to using TSQL stored procedures? Are you not using dynamic SQL due to the risk of SQL injection attacks? Have you seen performance issues with your current stored procedures used for searches? George Brown will bring examples he has come across in the past and will show how to use stored procedures with dynamic SQL, while still protecting against SQL injection attacks.