Initially, I balked. If your column is supposed to be an int and your query returns "Donald Trump is a douche", then your database is seriously broken. While this initial reaction is correct, it doesn't prevent the database from getting broken, but there is a way to build and automatically use such tests in the Microsoft stack. MSDN contains a few articles on the subject. Click here for a quick primer.
You could test your objects, views, even and especially any stored procedures. This code should be tested just as any other code written should be tested. If you have that 100% code coverage rule, and you aren't writing SQL unit tests...well, you aren't meeting your own definition of done are you?