Monthly Archives: June 2011

Displaying thousand seperators in SQL numbers

If you want to display a number 999999999.99 as 999,999,999.99 then it’s normally best to do this in the front end application but if you must do it in sql the way to do it is with the money type. … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , | Leave a comment

SQL Server 2008 Auditing – Database Audit

To create an audit you need to do the following Audit: Define where the audit data goes Audit Specification: Define what goes in to the audit Analyse: Find out what has been audited and view this in a meaningful way … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , | 6 Comments