SQL:创建过程时出错 [英] SQL: Error on create procedure
本文介绍了SQL:创建过程时出错的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
EmployeeName nvarchar(50),
地址nvarchar(50),
电话号码(50),
部门nvarchar(50) ,
性别nvarchar(50),
IsAvailable位)
- 添加程序
创建 过程 add_Emp @ EmployeeNo nvarchar ( 50 ), @EmployeeName nvarchar ( 50 ), @Address nvarchar ( 50 ), @Phone nvarchar ( 50 ), @部门 nvarchar ( 50 ), @ Gender nvarchar ( 50 ), @ IsAvailable 位
AS
开始
插入 进入 employee1(EmployeeNo, EmployeeName,Address,Phone,Department,Gender,IsAvailable) values ( @ EmployeeNo , @ EmployeeName , @ Address , @ Phone , @ Department , @ Gender , @ IsAvailable )
end
---错误消息
Quote:Msg 111,Level 15,Sta te 1,过程add_Emp,第12行'CREATE / ALTER PROCEDURE'必须是查询批处理中的第一个语句。
解决方案
>
错误消息说明解决方案本身。你不能在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 位</ span>
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
这篇关于SQL:创建过程时出错的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文