{{theTime}}

Search This Blog

Total Pageviews

Msg 4104, Level 16, State 1, Line 1 The multi-part identifier could not be bound (SQL Exception)

What is this exception?

Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "pkt.orderno" could not be bound.

Explanation:

  The executed sql query table alias is not correctly used to fetch the table column data.

Fix:

Find the table alias name used in select statement and correct the alias name. In this error the table alias is 'pkt' and the column referred is orderno.  In my query the table alias was 'pks' not 'pkt', hence the error.

1 comment:

Solar Kansas said...

Thank you for writing thiis

gradlew : The term 'gradlew' is not recognized as the name of a cmdlet, function, script file , or operable program

The command gradlew was not found, but does exist in the current location.  Windows PowerShell does not load commands from the current locat...