create procedure udsp_SelectOperationEnterpriseTableContent
-- (if oef_ImpVendorEnterpriseTag=1 select ''√'') 发货卖方,
as
declare @SelectStatement nvarchar(512)
set @SelectStatement='select oef_Index 流水号,
oef_Name 单位名称,
(select oeaf_Name from udfdt_OperationEnterpriseArea where oeaf_Index=oef_AreaIndex) 隶属地区,
oef_PostCode 邮政编码,
oef_ArtificialPerson 法人,
oef_Constituent 联络人,
oef_AccountBank 开户银行,
oef_BankAccount 银行帐号,
oef_RatePayingAccount 纳税人识别号,
(select b.oef_Name from udsdt_OperationEnterprise b where b.oef_Index=oef_TransportationEnterpriseIndex) 承运单位,
(select c.oef_Name from udsdt_OperationEnterprise c where c.oef_Index=oef_ConsigneeEnterpriseIndex) 代收单位,
oef_ImpVendorEnterpriseTag 发货卖方,
oef_ImpVendeeEnterpriseTag 发货买方,
oef_ExpVendorEnterpriseTag 退货卖方,
oef_ExpVendeeEnterpriseTag 退货买方,
oef_TransportationEnterpriseTag 承运人,
oef_ConsigneeEnterpriseTag 代收人,
oef_AssayEnterpriseTag 化验人,
oef_SpotCheckEnterpriseTag 抽样人 from udsdt_OperationEnterprise'
execute(@SelectStatement)goexec udsp_selectoperationenterprisetablecontent上面是我写的一个存储过程,并且调用存储过程的语句如果把从承运单位以后到from子句之间的部分CUT掉,执行就正常,如不CUT就说什么udsdt_opera这里有语法错误?看了半天也没看出来是哪里的错误,谁能帮助指正一下!
-- (if oef_ImpVendorEnterpriseTag=1 select ''√'') 发货卖方,
as
declare @SelectStatement nvarchar(512)
set @SelectStatement='select oef_Index 流水号,
oef_Name 单位名称,
(select oeaf_Name from udfdt_OperationEnterpriseArea where oeaf_Index=oef_AreaIndex) 隶属地区,
oef_PostCode 邮政编码,
oef_ArtificialPerson 法人,
oef_Constituent 联络人,
oef_AccountBank 开户银行,
oef_BankAccount 银行帐号,
oef_RatePayingAccount 纳税人识别号,
(select b.oef_Name from udsdt_OperationEnterprise b where b.oef_Index=oef_TransportationEnterpriseIndex) 承运单位,
(select c.oef_Name from udsdt_OperationEnterprise c where c.oef_Index=oef_ConsigneeEnterpriseIndex) 代收单位,
oef_ImpVendorEnterpriseTag 发货卖方,
oef_ImpVendeeEnterpriseTag 发货买方,
oef_ExpVendorEnterpriseTag 退货卖方,
oef_ExpVendeeEnterpriseTag 退货买方,
oef_TransportationEnterpriseTag 承运人,
oef_ConsigneeEnterpriseTag 代收人,
oef_AssayEnterpriseTag 化验人,
oef_SpotCheckEnterpriseTag 抽样人 from udsdt_OperationEnterprise'
execute(@SelectStatement)goexec udsp_selectoperationenterprisetablecontent上面是我写的一个存储过程,并且调用存储过程的语句如果把从承运单位以后到from子句之间的部分CUT掉,执行就正常,如不CUT就说什么udsdt_opera这里有语法错误?看了半天也没看出来是哪里的错误,谁能帮助指正一下!
/*
-----------
882(1 行受影响)
*/