2011-10-07 // http://pagead2.googlesyndication.com/pagead/show_ads.js Timestamp is a value that is incremented by the database whenever an insert or update operation is performed. Even though the name Timestamp could be a bit misleading, this value has no relevance to a clock related time. This only shows a linear progression of time. For an example , it isContinue reading “Using TimeStamp columns to keep track of database record versions”
Monthly Archives: October 2011
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”
I Learnt Today 