ALTER PROCEDURE EmpInfo
{
@EmpID INT
}
AS SELECT
[dbo].[Employee].[EmpID],
[dbo].[Employee].[EmpName],
[dbo].[Employee].[Phone],
[dbo].[Employee].[Sex],
[dbo].[Employee].[Address],
[dbo].[Employee].[ZoneCode]
FROM [dbo].[Employee]
WHERE [dbo].[Employee].[EmpID]=@EmpID消息 102,级别 15,状态 1,过程 EmpInfo,第 2 行
'{' 附近有语法错误。
消息 137,级别 15,状态 2,过程 EmpInfo,第 13 行
必须声明标量变量 "@EmpID"。
实在找不出错在哪,小弟谢谢了!
{
@EmpID INT
}
AS SELECT
[dbo].[Employee].[EmpID],
[dbo].[Employee].[EmpName],
[dbo].[Employee].[Phone],
[dbo].[Employee].[Sex],
[dbo].[Employee].[Address],
[dbo].[Employee].[ZoneCode]
FROM [dbo].[Employee]
WHERE [dbo].[Employee].[EmpID]=@EmpID消息 102,级别 15,状态 1,过程 EmpInfo,第 2 行
'{' 附近有语法错误。
消息 137,级别 15,状态 2,过程 EmpInfo,第 13 行
必须声明标量变量 "@EmpID"。
实在找不出错在哪,小弟谢谢了!
ALTER PROCEDURE EmpInfo
(
@EmpID INT
)
AS SELECT
[dbo].[Employee].[EmpID],
[dbo].[Employee].[EmpName],
[dbo].[Employee].[Phone],
[dbo].[Employee].[Sex],
[dbo].[Employee].[Address],
[dbo].[Employee].[ZoneCode]
FROM [dbo].[Employee]
WHERE [dbo].[Employee].[EmpID]=@EmpID
--{
(
@EmpID INT
)
--}
AS SELECT
[dbo].[Employee].[EmpID],
[dbo].[Employee].[EmpName],
[dbo].[Employee].[Phone],
[dbo].[Employee].[Sex],
[dbo].[Employee].[Address],
[dbo].[Employee].[ZoneCode]
FROM [dbo].[Employee]
WHERE [dbo].[Employee].[EmpID]=@EmpID
(
@EmpID INT
)