Is it possible to define a local function in a TSQL query? December 28, 2023 by Tarik No, there is no way — create/drop is the only choice.