SQL:创建过程时出错 [英] SQL: Error on create procedure

查看:78
本文介绍了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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆