I think rollback commit is a good standard approach especially if you have triggers / lots of related tables. peer review prior to committing the changes and also CTE's if...

Yep I know what you mean, the dbase design/input validation could be a lot better. Thank-you for all the replies. The following LIKE seems to work in a...

Not always as this relates to data on all of our customers databases. So one customer may have BB4 with the same code as BB4 5 but another could...

thanks for reply, yep so taking E1W 2VB as an example the lookup table might have

01 E1W 2

02 E1W 3

03 ...

If you constantly need to work extra hours because you feel you need to get projects completed in this way then the chances are that it isn't being managed correctly/lack...

The space savings are impressive and it does lend itself to a number of real-world situations but you also need to highlight the shortcomings of the XML data type as...