What you'll need:
Write a public method that will read your data, something that you will call from web service or other facade… Something along following lines:
public DataSet ReadSomeData(FilterOfSomeKind filter)
DON'T write unit test for this method! Just run test using TestDriven.NET. If your SQL is valid the test will succeed otherwise it will fail… And if your method survives the fact hat filter is null, of course.
It’s not thorough, but for simple check if you even got SQL syntax right, this is pure gold. Simple, ey?