无法绑定多部分标识符。 [英] The multi-part identifier could not be bound.

问题描述

嗨......我想从Trns_Enrollmentdetails更新Trns_Enrollmentmaster的详细信息..我从前端传递了一些细节，并从详细信息表中更新了剩余的详细信息...



当我尝试执行此查询时......我收到此错误



多部分标识符无法绑定。



这些参数来自详细信息表......任何人都可以给出建议。



我尝试了什么：

Hi... I want to update the details of Trns_Enrollmentmaster from Trns_Enrollmentdetails.. I'm passing few details from front end and remaining details updating from detail table...

When I'm trying to execute this query..I'm getting this error

The multi-part identifier could not be bound.

for those parameters taking from detail table...Can any one give suggestion for this.

What I have tried:

ALTER proc [dbo].[SP_T_PrimaryUpdate]


(@UHIDNO varchar(30),
@Yearautoid int,
@Membername varchar(50),
@ISPrimaryChanged bit,
@PrimaryChangeby varchar(50),
@Primarychangedon datetime,
@PrmaryChangedReason varchar(50),
@PrimaryChangedmembername varchar(50),
@PrimarychangeIP varchar(50))

AS
  BEGIN
        
        UPDATE Trns_Enrollmentmaster  SET Membername=@Membername,ISPrimaryChanged=@ISPrimaryChanged,
               Primarychangedon=@Primarychangedon,PrimaryChangeby=@PrimaryChangeby,PrimaryChangedmembername=@PrimaryChangedmembername,
               PrmaryChangedReason=@PrmaryChangedReason,
               PrimarychangeIP=@PrimarychangeIP, Age =a.age, Photo=a.photo, Gender = a.Gender
               
               SELECT a.age,a.photo,a.Gender FROM dbo.Trns_Enrollmentdetails AS a INNER JOIN dbo.Trns_Enrollmentmaster  ON a.UHIDNO=@UHIDNO and a.Yearautoid=@Yearautoid  AND Trns_Enrollmentmaster.UHIDNO=@UHIDNO AND Trns_Enrollmentmaster.Yearautoid=@Yearautoid 
      END

推荐答案

Google是你的朋友。此搜索为您提供了许多可能的答案：

多部分标识符无法绑定。 - Google搜索 [ ^ ]



...包括这个宝石：​​ sql - 什么是'多-part identifier'为什么不能绑定？ - 堆栈溢出 [ ^ ]

Google is your friend. This search turned up a lot of possible answersa for you:
The multi-part identifier could not be bound. - Google Search[^]

... including this gem: sql - What is a 'multi-part identifier' and why can't it be bound? - Stack Overflow[^]

使用连接时有可能列名可能相同..使用列的别名它在我的案例中有用......

There is a chance when using joins columns name may be same.. use alias name for the columns...It was worked in my case...

这篇关于无法绑定多部分标识符。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！