SQL SERVER FILE NAME FORMULA

SQL SERVER FILE NAME FORMULA

/* SQL SERVER FILE NAME FORMULA */

-- HI VIEWERS

-- TODAY WE WILL LOOK AT THE SQL FILE NAME FUNCTION

-- THEORY:

-- SELECT FILE_NAME(ENTER FILE NAME ID NUMBER HERE) AS [ALIAS NAME];

-- EXAMPLE:

SELECT FILE_NAME(2) AS [FILE_NAME];

-- HIGHLIGHT IT AND CLICK EXECUTE OR (F5)

-- YOU CAN GIVE THE COLUMN AN ALIAS OR COLUMN NAME BY USING AS BEFORE THE NAME

-- THE FILE NAME FOR ID 2 AS SEEN BELOW IS

-- AdventureWorksDW2012_Log

-- THAT IS IT