October 18, 2012
Recently, I needed to find out the schema of a resultset returned by a Stored Procedure so I could pass some failing SQL Unit Tests. I needed to know the columns, the column order and exact datatypes. Without access to a client to run the procedure I needed a way to do this with just […]
August 22, 2012
I’ve recently put together an article on using SQL Test/tSQLt, which you can find here. However, I wanted to briefly talk about the alternatives as I see them. Before any commercial testing tools were around we could just use a combination of manual scripts that called procedures and used temporary tables to hold data. It […]
August 15, 2012
I think it depends on your requirements, I’ve used a similar flag to indicate “active” records but this also had an automated process to move inactive records into a separate table so those operations could batched.