Update tempinspanalyse Set itemname = T.itemname From (Select itemno,itemname From item) T,tempinspanalyse Where T.itemno = tempinspanalyse.itemno上面这条语句提示如下问题:
Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.
请问是什么原因?
Server: Msg 446, Level 16, State 9, Line 1
Cannot resolve collation conflict for equal to operation.
请问是什么原因?
From (Select itemno,itemname From item)T
Where T.itemno =itemno试一下
-----------------------
Update a Set itemname = T.itemname
From (Select itemno,itemname From item) T,tempinspanalyse a
Where T.itemno = a.itemno
Update tempinspanalyse Set itemname = T.itemname
From item T,tempinspanalyse
Where T.itemno = tempinspanalyse.itemno
[id] [int] IDENTITY (1, 1) NOT NULL ,
[row] [int] NULL ,
[ItemNO] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ItemName] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[Description] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[Category] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
[Currency] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[UnitCost] [float] NULL ,
[Unitprice] [float] NULL ,
[Unit] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Package] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[Location] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[picture] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[picture_flag] [varchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[last_update_time] [datetime] NULL ,
[rowguid] uniqueidentifier ROWGUIDCOL NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[Tempinspanalyse] (
[ItemNO] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ItemName] [varchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LotQty] [int] NULL ,
[SMPLQty] [int] NULL ,
[CrQty] [int] NULL ,
[MaQty] [int] NULL ,
[MiQty] [int] NULL ,
[TtlQty] [int] NULL ,
[AccQty] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO按上面两种方法还是同样的问题,以上是相关的两张表。
[ItemNO] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ItemName] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
[LotQty] [int] NULL ,
[SMPLQty] [int] NULL ,
[CrQty] [int] NULL ,
[MaQty] [int] NULL ,
[MiQty] [int] NULL ,
[TtlQty] [int] NULL ,
[AccQty] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
From tempinspanalyse,(Select itemno,itemname From item) T
Where tempinspanalyse.itemno = T.itemno
Update tempinspanalyse Set itemname = T.itemname
From item T,tempinspanalyse
Where T.itemno = tempinspanalyse.itemno COLLATE Chinese_PRC_CI_AS