Is there a way to find out if a query will return data before it is made?
I have an unusual problem. My code uses a 3rd party dll to make database calls from my silverlight client to a sql server database. In my code, I make dozens of calls one after the other. All of the calls execute successfully. But sometimes the result of a successful call is an empty data set. Is there any way I can modify my call so that in the return will tell me what call was made that returned the empty data set?
The 3rd party software pretty much returns whatever command I give as a query I test in Microsoft Server Management Studio. Is there some sort of SQL command that will test if some sort of SELECT statement will return data and can that return statement contain the ID's or parameters used to make the statement?