Category: User Defined Function

  • T-SQL Function to Get the Default Backup Folder

    Again, DBA’s are often faced with adhoc backup tasks that shall dump relevant data or log to the existing backup location for all other data/log dumps. Quick way to do so will invovling concatenating dynamic sql commands with the default backup folder location. [sourcecode language=”sql”] /* Script to create a function to get default backup…

  • Two Examples of Recursion with T-SQL

    T-SQL is very good for dealing with set-based data, but it doesn’t shy away from recursion either. You can use either user defined functions (UDF) or common table expression (CTE) to achieve this and I put up hereunder two examples to solve the claissic problem of finding the organization levels of employees and their managers.…