Search code examples
sqlsql-serveraliasdata-warehouse

getaliasesby command on SQL query

now im investigating SQL Query for making Datawarehouse. I found this query on it :

MAX(dbo.GetAliasesByWo(b_1.wo_part, b_1.wo__dec01, RTRIM(LTRIM(b_1.wo__chr01)), RIGHT(RTRIM(LTRIM(b_1.wo_rmks)), 1))) AS list_wo, 
MAX(dbo.GetAliasesByWo1(b_1.wo_part, b_1.wo__dec01, RTRIM(LTRIM(b_1.wo__chr01)), RIGHT(RTRIM(LTRIM(b_1.wo_rmks)), 1))) AS list_wo1, 
MAX(dbo.GetAliasesByWo2(b_1.wo_part, b_1.wo__dec01, RTRIM(LTRIM(b_1.wo__chr01)), RIGHT(RTRIM(LTRIM(b_1.wo_rmks)), 1))) AS list_wo2

did anyone knows whats the meaning ? could you explain to me ?

Solution

  • You can use sp_helptext command to view the definition.I think the given GetAliasesByWo is an user-defined function you can check the definititon with the below query: 

    EXEC [ServerName].[DatabaseName].dbo.sp_helptext 'dbo.GetAliasesByWo'