>
错误消息说明解决方案本身。你不能在create procedure语句上面添加声明语句，Create语句必须是查询批处理中的第一个语句。删除那些变量声明它应该有效。



问候，

Amol Birar

在创建过程语句之前放置GO。 GO语句必须单独排在一行：

  GO  
 create   procedure  add_Emp  @ EmployeeNo   nvarchar （ 50 ）， @ EmployeeName   nvarchar （ 50 ）， @ Address   nvarchar （ 50 ）， @ Phone   nvarchar （ 50 ）， @ Department   nvarchar （ 50 ）， @ Gender   nvarchar （ 50 ）， @ IsA vailable  位 
 AS  
开始 
插入 进入 employee1（EmployeeNo，EmployeeName，Address，电话，部门，性别，IsAvailable）值（ @ EmployeeNo ， @EmployeeName ， @ Address ， @ Phone ， @Department ， @ Gender ， @ IsAvailable ）
端跨度> 

EmployeeName nvarchar(50),
Address nvarchar(50),
Phone nvarchar(50),
Department nvarchar(50),
Gender nvarchar(50),
IsAvailable bit)

--add procedure

create procedure add_Emp @EmployeeNo nvarchar(50),@EmployeeName nvarchar(50),@Address nvarchar(50),@Phone nvarchar(50),@Department nvarchar(50),@Gender nvarchar(50),@IsAvailable bit
AS
Begin
insert into employee1(EmployeeNo,EmployeeName,Address,Phone,Department,Gender,IsAvailable) values (@EmployeeNo,@EmployeeName,@Address,@Phone,@Department,@Gender,@IsAvailable)
end

---error message

Quote:

Msg 111, Level 15, State 1, Procedure add_Emp, Line 12 'CREATE/ALTER PROCEDURE' must be the first statement in a query batch.

Hi,
Error message states solution itself. you cannot add declare statements above create procedure statement,Create statement has to be first statement in query batch .Remove those variable declaration and it should work.

Regards,
Amol Birar

Place GO right before your Create procedure statement. The GO statement must be on a line by itself:

GO
create procedure add_Emp @EmployeeNo nvarchar(50),@EmployeeName nvarchar(50),@Address nvarchar(50),@Phone nvarchar(50),@Department nvarchar(50),@Gender nvarchar(50),@IsAvailable bit
AS
Begin
insert into employee1(EmployeeNo,EmployeeName,Address,Phone,Department,Gender,IsAvailable) values (@EmployeeNo,@EmployeeName,@Address,@Phone,@Department,@Gender,@IsAvailable)
end