SQL SERVER FILE IDEX FORMULA

SQL SERVER FILE IDEX FORMULA

/* SQL SERVER FILE IDEX FORMULA FOR AdventureWorksDW2012_Log */

-- HI VIEWERS

-- TODAY WE WILL LOOK AT THE FILE IDEX FORMULA

-- THE FILE IDEX FORMULA RETRIEVES THE FILE IDEX VALUE

-- FROM A FILE NAME

-- WE BEGIN BY ENTERING THE KEYWORD SELECT

-- FOLLOWED BY THE FILE IDEX FORMULA

-- ENCLOSED WITHIN IT'S BRACKETS

-- WILL BE THE FILE NAME IN SINGLE QUOTES

-- LIKE SO ...

SELECT FILE_IDEX('AdventureWorksDW2012_Log') AS [FILE IDEX];

-- NOTICE THE VALUE OF 2

-- NOTICE THE COLUMN NAME GIVEN AS AN ALIAS OF [FILE IDEX]

-- THAT IS IT