Message
From
15/07/2003 20:19:05
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
How to return an empty result
Miscellaneous
Thread ID:
00810496
Message ID:
00810496
Views:
53
Hi,

I want to do a select statement to return an empty result without consuming resources.

Let's say I just want to bring an empty result from the customers table, I could do "SELECT * FROM customer WHERE customer_id = -8994849" something like this but if the table is huge I imagine it will consume resources.

Any way just to bring an empty result set without consuming resources?

Thanks
Next
Reply
Map
View