{{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.

No comments:

Kafka Consumer Parallelism

Kafka Parallel Consumer Options: Key-level parallelism:  Multiple threads process the messages from a single partition in parallel while ma...