General information
Forum:
Microsoft SQL Server
Title:
How to return an empty result
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only