CREATE PROCEDURE AssignRegular
@department AS INT,
@project AS VARCHAR(100),
@Employee AS VARCHAR(100)
AS
BEGIN
DECLARE @result AS INT
SELECT @result = COUNT(*)
FROM Managers_assign_Regular_Emplyee_Projects
WHERE regular_employee = @Employee
我在员工附近遇到语法错误,不知道为什么
您缺少与 BEGIN 匹配的 END:
create proc AssignRegular
@department as int
,@project as varchar(100)
,@Employee as varchar(100)
as
BEGIN
Declare @result as int
select @result = count(*) from Managers_assign_Regular_Emplyee_Projects where regular_employee=@Employee
END
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句