How to use (escape) single quotation mark in sql statements

06-10-2011 // http://pagead2.googlesyndication.com/pagead/show_ads.js We all get that day when we get an exception complaining about the single quotation or apostrophe that was in our SQL statement. The best advisable thing to do is to use stored procedures so that all data are passed as parameters. However there are situations we have to use in-line SQLContinue reading “How to use (escape) single quotation mark in sql statements”

A stored procedure that can auto-genarate SQL queries using exec method

06-10-2011 http://pagead2.googlesyndication.com/pagead/show_ads.js Have you ever wanted to write a flexible and dynamic¬†stored procedure that would allow you to send the table name as a parameter? Have you ever wanted to write a flexible¬†and dynamic stored procedure that would allow you to send only the condition but also the column name you want to include inContinue reading “A stored procedure that can auto-genarate SQL queries using exec method”