Over on Experts Exchange I saw a question that I get all the time, “How do I format this DATETIME like x?” If they’re asking to learn, I point them over to the CAST and CONVERT article on msdn. If you wish to change a Microsoft SQL DATETIME column from the standard format 2008-01-28 12:43:13.210…
Month: January 2008
sql db record number
Over on Experts Exchange someone asked, once I insert a record into the table, how can I retrieve the primary key that was just inserted. This is a topic I covered back in 2005 in my post SQL 101 – System Functions. In this post I introduced you to @@IDENTITY. If you are unfamiliar with…
Return a Success/Failure to a Job based on a SQL query?
Over on Experts Exchange, someone posted a question I felt I could answer. The user posted a question on how to return a failure and not run a job. I originally took the approach of putting a query at the top of the queries run by the job that would query the table of failure…
Advice regarding on-line storage versus terabyte drives
Over at Experts Exchange, a user asked for some advice on using online (or off-site storage) for a collection of video files. This is something I have been discussing with my friends and co-workers for some time. I thought I’d try to help out. Looking at the amount of storage, 2 terabytes, I had to…