SQL SERVER FILE ID FORMULA

SQL SERVER FILE ID FORMULA

/* SQL SERVER FILE ID FORMULA FOR AdventureWorksDW2012_Log */

-- HI VIEWERS

-- Today, we will look at displaying the file ID for a log file

-- First we start of with the keyword SELECT

-- Then we enter the formula FILE_ID

-- Within the file ID formula we enter the file name in single quotes ''

-- THEORY:

-- SELECT FILE_ID(FILE NAME) AS [ALIAS NAME]

--EXAMPLE:

SELECT FILE_ID('AdventureWorksDW2012_Log') AS [FILE ID];

-- THE CLICK RUN OR (F5) OR EXECUTE

-- THAT IS IT