在Visual Studio2008内部SQL Server中创建存储过程 [英] creating stored procedure in visual studio2008 internal sql server

问题描述

我正在尝试通过查询在Visual Studio的内部sqlserver2005中创建存储过程

i am trying to create a stored procedure in my internal sqlserver2005 of visual studio by the query

create procedure usp_insert(@tower nvarchar(20),@floor nvarchar(20),@flatno nvarchar(20),@status nvarchar(20),@color nvarchar(20))
as
insert into booksta values(@tower,@floor,@flatno,@status,@color)

但出现错误

'CREATE/ALTER PROCEDURE'必须是查询批处理中的第一条语句.'我的查询是否有任何问题

but got a error

‘CREATE/ALTER PROCEDURE’ must be the first statement in a query batch.’ is there any problem with my query

推荐答案

SSMS不能解释批处理整个过程，但有两个单独的命令.

也许像这样:

The SSMS isn''t interpreting the batch as a whole procedure but two separate commands.

Perhaps like this:

create procedure usp_insert(@tower nvarchar(20),@floor nvarchar(20),@flatno nvarchar(20),@status nvarchar(20),@color nvarchar(20))
as
begin
   insert into booksta values(@tower,@floor,@flatno,@status,@color);
end;
go

另外，在运行该批处理时，编辑器应仅具有该批处理，否则您可以在执行批处理之前仅选择包含过程定义的行

Also the editor should have only that batch when yuo run it or you can select just the lines containing the procedure definition prior to executing the batch

尝试为

create procedure usp_insert

@tower nvarchar(20),@floor nvarchar(20),@flatno nvarchar(20),@status nvarchar(20),@color nvarchar(20)

as
BEGIN

insert into booksta values(@tower,@floor,@flatno,@status,@color)
END

似乎上述创建过程中还存在其他SQL语句.用GO语句将它们分开.
试试这个:

it seems like there are other SQL statements present above create procedure. Separate them with a GO statement.
Try this:

GO
create procedure usp_insert(
             @tower nvarchar(20)
            ,@floor nvarchar(20)
            ,@flatno nvarchar(20)
            ,@status nvarchar(20)
            ,@color nvarchar(20)
           )
as
SET NOCOUNT ON
insert into booksta values(@tower,@floor,@flatno,@status,@color)
GO

这篇关于在Visual Studio2008内部SQL Server中创建存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！