本文介绍了Sql查询在Sql Server Management Studio 2014上运行,但在Visual Studio 2013上不起作用的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

这是查询

在Sql Server Management Studio中

In Sql Server Management Studio

从Speciality,Doctor_Info中选择Speciality_Name,其中Doctor_Info.Speciality_ID = Speciality.Speciality_ID和Doctor_Info.Speciality_ID = 1

select Speciality_Name from Speciality,Doctor_Info where Doctor_Info.Speciality_ID = Speciality.Speciality_ID and Doctor_Info.Speciality_ID = 1

在Visual Studio中

In Visual Studio

"从Speciality,Doctor_Info中选择Speciality_Name,其中Doctor_Info.Speciality_ID = Speciality.Speciality_ID和Doctor_Info.Speciality_ID =' + comboBoxDoctorSSN.Text +''';;

"Select Speciality_Name from Speciality,Doctor_Info where Doctor_Info.Speciality_ID = Speciality.Speciality_ID and Doctor_Info.Speciality_ID = '" + comboBoxDoctorSSN.Text + "'";

任何人都可以解决这个问题吗?

Can anyone please solve the issue?

推荐答案

可能还需要一段代码摘录来告诉您您在做什么.

Will probably need a code excerpt as well to tell what you are doing.


这篇关于Sql查询在Sql Server Management Studio 2014上运行,但在Visual Studio 2013上不起作用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-21 08:32