{{theTime}}

Search This Blog

Total Pageviews

The multi-part identifier "prod.product_id" could not be bound.

Sql Exception:

Msg 4104, Level 16, State 1, Line 266
The multi-part identifier "prod.product_id" could not be bound.

Fix:
Make sure the alias name "prod" exists in sql and correctly spelled.

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Generate Insert Sql from Select Statement

SELECT 'INSERT INTO ReferenceTable (ID, Name) VALUES (' +        CAST(ID AS NVARCHAR) + ', ''' + Name + ''...