Monday, 14 November 2016

SQL SERVER INDEX COLUMN FORMULA index a column through sql query

SQL SERVER INDEX COLUMN FORMULA

-- THEORY

-- SELECT INDEX_COL('TABLE_NAME',ColumnNumber1,IDNumber1) AS Index Column Name;

-- EXAMPLE

SELECT INDEX_COL('AdventureWorksDW2012.dbo.DimProduct',1,1) AS IndexCol;

No comments:

Post a Comment