语法上没有问题，看输出语句后，检查下关键词间的空格吧
fsdfsewtf
采纳率100%
2017-04-02 13:23 浏览 972
已采纳
新手求帮忙，请大神帮忙解释一下sql语句的问题
5请大神帮忙看看，这几句SQL语句有什么语法问题！！！
string sql = "select EmployeeId,EmployeeName,Gender,Birthday,DepartmentName from Employees";
sql += "inner join EmployeeDepartment on Employees.DepartmentId=EmployeeDepartment.DepartmentId";
sql += "where Employees.DepartmentId="+departmentId;
执行后的语句是这样：
where那好像没有隔开，求大神教具体应该怎么改
- 点赞
- 写回答
- 关注问题
- 收藏
- 复制链接分享
- 邀请回答
6条回答 默认 最新
- 已采纳 点赞 评论 复制链接分享
-
执行完后的sql语句是这样的:
select EmployeeId,EmployeeName,Gender,Birthday,DepartmentName from Employeesinner join EmployeeDepartment on Employees.DepartmentId=EmployeeDepartment.DepartmentIdwhere Employees.DepartmentId=1
问题在拼接的地方没有空格隔开.点赞 2 评论 复制链接分享 -
把拼接好的sql语句打印看一下，我怀疑是inner 和where的空格问题
点赞 1 评论 复制链接分享 -
两个字符串连接了，但是中间没有空格呀Employeesinner这样肯定设别不错来，不要这样写，容易错
点赞 评论 复制链接分享 -
string sql = "select EmployeeId,EmployeeName,Gender,Birthday,DepartmentName from Employees";
sql += "inner join EmployeeDepartment on Employees.DepartmentId=EmployeeDepartment.DepartmentId";
sql += "where Employees.DepartmentId="+departmentId;string sql复用了吧？
string sql = "select EmployeeId,EmployeeName,Gender,Birthday,DepartmentName from Employees"- "inner join EmployeeDepartment on Employees.DepartmentId=EmployeeDepartment.DepartmentId"+ "where Employees.DepartmentId="+departmentId; 不知道对不对？
点赞 评论 复制链接分享 -
StringBuilder sql = new StringBuilder(" select EmployeeId,EmployeeName,Gender,Birthday,DepartmentName from Employees inner join EmployeeDepartment on Employees.DepartmentId=EmployeeDepartment.DepartmentId");
sql.Append(string.Format(" where Employees.DepartmentId ={0}", departmentId));
ExcuteSql(sql.toString());点赞 评论 复制链接分享