There is an issue with Leap Year and DateAdd function that can appear if you want to compare two dates from different years and using some date value ...
When you need select Min or Max value from table with one column, it's easy SQL task. A little harder is same request when you want to find minimum va...
Are you trying convert float to numeric and you get "Arithmetic overflow error converting float to data type numeric" error? This could happen even if...
When you alter view or stored procedure and you realize, previous version wasn't saved and you need it. Or you want recover SQL script immediately aft...
Sometimes it can happen, that you compare two strings, which looks exactly sames, but they are processed as not equal. Also when you use SELECT DISTIN...