Monthly Archives: October 2011

Using TimeStamp columns to keep track of database record versions

2011-10-07 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 … Continue reading

Posted in Database-Concepts, SQL Server | Tagged , , , , , , , , | Leave a comment

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

06-10-2011 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 … Continue reading

Posted in SQL Server | Tagged , , , , | Leave a comment

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

06-10-2011 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 … Continue reading

Posted in Oracle, SQL Server | Tagged , , , | Leave a comment