Binding information is invalid--哪位大佬能解答一下?

yinsuxia 2018-03-06 05:27:46
OLE DB provider "SQLNCLI10" for linked server "KUP" returned message "Binding information is invalid.".
Msg 7341, Level 16, State 2, Line 1
Cannot get the current row value of column "[KUP].[KUP].[dbo].[J_V_Product].Sterilization" from OLE DB provider "SQLNCLI10" for linked server "KUP".
这个是我在查询一个linked server时返回的错误,大佬们帮忙看看是怎么造成的呢?其中,J_V_product是个视图。里面就是个查询语句。引用表的语句:


CREATE TABLE [dbo].[J_Product](
[ItemID] [uniqueidentifier] NOT NULL,
[ItemCode] [varchar](100) NOT NULL,
[ItemType] [int] NOT NULL,
[Name_CN] [nvarchar](1000) NULL,
[Name_EN] [nvarchar](1000) NULL,
[UOM] [nvarchar](50) NULL,
[IsImported] [bit] NULL,
[ApplicationScope] [nvarchar](max) NULL,
[Description] [nvarchar](max) NULL,
[REF] [nvarchar](max) NULL,
[SPEC] [nvarchar](max) NULL,
[Material] [nvarchar](1000) NULL,
[KeyProductFlag] [bit] NOT NULL,
[NewProductFlag] [bit] NOT NULL,
[KitFlag] [bit] NOT NULL,
[CompanyCategory1] [nvarchar](1000) NULL,
[CompanyCategory2] [nvarchar](1000) NULL,
[J1] [nvarchar](1000) NULL,
[J2] [nvarchar](1000) NULL,
[J3] [nvarchar](1000) NULL,
[Manufacturer] [nvarchar](max) NULL,
[MinPrice] [decimal](18, 2) NULL,
[MaxPrice] [decimal](18, 2) NULL,
[AlertPrice] [decimal](18, 2) NULL,
[DivisionID] [uniqueidentifier] NULL,
[StructureAndComposition] [nvarchar](max) NULL,
[LifeDescription] [nvarchar](max) NULL,
[TradeName] [nvarchar](1000) NULL,
[OneTimeUsage] [bit] NULL,
[AgentRegAddress] [nvarchar](1000) NULL,
[AgentName] [nvarchar](1000) NULL,
[AgentTelNumber] [nvarchar](50) NULL,
[StandardCode] [nvarchar](max) NULL,
[ManufacturerAddress1] [nvarchar](1000) NULL,
[ManufacturerAddress2] [nvarchar](1000) NULL,
[RegProductName] [nvarchar](1000) NULL,
[PriceBuffer1] [decimal](18, 2) NULL,
[PriceBuffer2] [decimal](18, 2) NULL,
[Indication] [nvarchar](max) NULL,
[ManufacturerEN] [nvarchar](1000) NULL,
[MinSPEC] [nvarchar](1000) NULL,
[Contraindication] [nvarchar](max) NULL,
[Memo] [nvarchar](500) NULL,
[StorageCondition] [nvarchar](max) NULL,
[ServiceProvider] [nvarchar](max) NULL,
[OriginalCountry] [nvarchar](max) NULL,
[Brand] [nvarchar](50) NULL,
[IsEquipment] [bit] NULL,
[IsImplantation] [bit] NULL,
[IsConsumptive] [bit] NULL,
[ValuePeriod] [varchar](50) NULL,
[PackageMaterial] [nvarchar](50) NULL,
[PackageRate] [decimal](18, 2) NULL,
[Sterilization] [nvarchar](max) NULL,
[InspectionReportNumber] [nvarchar](50) NULL,
[InspectionReportDate] [date] NULL,
[DT] [datetime] NULL,
[ST] [int] NOT NULL,
[MinPricingSPEC] [nvarchar](50) NULL,
[SterilizationMethod] [nvarchar](max) NULL,
[JNJUnitRate] [decimal](18, 2) NULL,
[MinPackageRate] [decimal](18, 2) NULL,
[MinPackageName] [nvarchar](50) NULL,
[JNJOutboundPackageName] [nvarchar](50) NULL,
[JNJStandardUnitRate] [decimal](18, 2) NULL,
CONSTRAINT [PK_J_Product] PRIMARY KEY CLUSTERED
(
[ItemID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 单品 2组件 3组套' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'J_Product', @level2type=N'COLUMN',@level2name=N'ItemType'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1:进口 2:国产' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'J_Product', @level2type=N'COLUMN',@level2name=N'IsImported'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'适用范围' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'J_Product', @level2type=N'COLUMN',@level2name=N'ApplicationScope'
GO

ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_ItemType] DEFAULT ((1)) FOR [ItemType]
GO

ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_IsImported] DEFAULT ((1)) FOR [IsImported]
GO

ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_KeyProductFlag] DEFAULT ((0)) FOR [KeyProductFlag]
GO

ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_NewProductFlag] DEFAULT ((0)) FOR [NewProductFlag]
GO

ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_KitFlag] DEFAULT ((0)) FOR [KitFlag]
GO

ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_OneTimeUsage] DEFAULT ((0)) FOR [OneTimeUsage]
GO

ALTER TABLE [dbo].[J_Product] ADD CONSTRAINT [DF_J_Product_ST] DEFAULT ((1)) FOR [ST]
GO

...全文
789 1 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
1 条回复
切换为时间正序
请发表友善的回复…
发表回复
shoppo0505 2018-03-07
  • 打赏
  • 举报
回复
你的view里面有Sterilization这个列么?

34,837

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧