I don;t think there is any way in sql server in any version\Edtion which will allow to allocate or define a quota for a query.

my question is why do you want such thing to happen?

sql server has a reserved memory space known as buffer cache which is divided majorily into 2 parts

data cache and procedure cache .

and how much and how less depends on the configurtion of minimun and maximun server memory setting under sp_configure.

pls. eloborate your requirement a bit more clearly...