大家帮忙看一下这条sql语句。

Question

CREATE PROCEDURE dbo.Employee_GetEmployee
@Input int
AS
select *from Employee where EmployeeID=select EmployeeID from Employee-Department where TeamID=@Input and IsLeader='true'RETURN 
报错
Server: Msg 156, Level 15, State 1, Procedure Employee_GetEmployee, Line 4
Incorrect syntax near the keyword 'select'.

Answer 1

CREATE PROCEDURE dbo.Employee_GetEmployee
@Input int
AS
select * from Employee where EmployeeID=(select EmployeeID from [Employee-Department] where TeamID=@Input and IsLeader='true')

Answer 2

这表名[Employee-Department]谁给定义的？BS一个