have stored proc always return a blank record : The Official Microsoft ASP.NET Forums

ASP.NET

Complete Thread

- Reply
TabAlleman

All-Star

15727 Points

2721 Posts
Re: have stored proc always return a blank record

Apr 05, 2012 08:41 PM|LINK
```
IF EXISTS(SELECT * FROM MyTable WHERE Condition=true)
  SELECT * FROM MyTable WHERE Condition=true
ELSE
  SELECT NULL AS Column1, NULL AS Column2, NULL AS Column3, [etc...]
```
-Tab Alleman
- Marked as answer by MyronCope on Apr 06, 2012 01:24 PM