I'm building an automated build procedure, one of the steps is to create a database and it's structure/procedures/functions etc.<BR><BR>Clearly I can script the entire db creation job in sql and use ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

In this third in a series on working smarter with T-SQL, let's give the built-in sp_executesql stored proc a go. In my previous posts, I've described some methods for generating and executing T-SQL ...