Maybe this is a strange question, but is there a way to add a single row (or several) to the return set of a SELECT statement?

So it came up that several of our devs are writing their TSQL entirely in code using ADO.NET and submitting their queries that way.<BR><BR>Initially the idea was sprocs for all inserts, updates, etc..