SQL Server存储过程返回一个表 [英] SQL server stored procedure return a table
问题描述
我有一个带两个参数的存储过程.我可以在Server Management Studio中成功执行它.它向我显示了预期的结果.但是,它还会返回一个返回值.
I have a stored procedure that takes in two parameters. I can execute it successfully in Server Management Studio. It shows me the results which are as I expect. However it also returns a Return Value.
它已经添加了这一行,
SELECT 'Return Value' = @return_value
我希望存储过程返回它在结果中显示的表,而不是返回值,因为我正在从MATLAB调用此存储过程,并且返回的所有结果都是true或false.
I would like the stored procedure to return the table it shows me in the results not the return value as I am calling this stored procedure from MATLAB and all it returns is true or false.
我是否需要在存储过程中指定应返回的内容?如果是这样,如何指定4列的表格(varchar(10),float,float,float)?
Do I need to specify in my stored procedure what it should return? If so how do I specify a table of 4 columns (varchar(10), float, float, float)?
推荐答案
过程无法返回这样的表.但是,您可以从过程中的表中进行选择,然后将其定向到表(或表变量)中,如下所示:
A procedure can't return a table as such. However you can select from a table in a procedure and direct it into a table (or table variable) like this:
create procedure p_x
as
begin
declare @t table(col1 varchar(10), col2 float, col3 float, col4 float)
insert @t values('a', 1,1,1)
insert @t values('b', 2,2,2)
select * from @t
end
go
declare @t table(col1 varchar(10), col2 float, col3 float, col4 float)
insert @t
exec p_x
select * from @t
这篇关于SQL Server存储过程返回一个表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!