is there a way of using global functions or paramenters in TSQL? Simply I want it to do this like in Access.
SELECT * FROM table1 WHERE (((table1.id)=current_productID1())); this is achieved by creating a funtion in Access.
Is there a way to do this in TSQL? This criteria filter will be used in different queries/views etc. What is the feature I want that will do this? thanks
thanks for that but I dont think that is what I'm looking for. This simply runs the same query every time yo call it doesnt it?. I want to set up a function/variable and apply this as a filter/criteria.
global function or parameter
Posted - 11/21/2012 : 06:45:51
