- 新手求帮忙，请大神帮忙解释一下sql语句的问题
-
请大神帮忙看看，这几句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那好像没有隔开，求大神教具体应该怎么改
-
- zhangyuanyincsdn 好的，不客气
- 2 年多之前 回复
-
- zhangyuanyincsdn 不好意思，用手机简写打错了， 是在每行结尾的双引号前加空格
- 2 年多之前 回复
-
- zhangyuanyincsdn 回复fsdfsewtf: 在前两句语句最后，就是每行结尾的分号前，手动增加个空格即可
- 2 年多之前 回复
执行完后的sql语句是这样的:
select EmployeeId,EmployeeName,Gender,Birthday,DepartmentName from Employeesinner join EmployeeDepartment on Employees.DepartmentId=EmployeeDepartment.DepartmentIdwhere Employees.DepartmentId=1
问题在拼接的地方没有空格隔开.
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());