blocks|key|1905730|text|过程不能返回这样的表。但是，可以从过程中的表中进行选择，并将其定向到表(或表变量)中，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1905731|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|code-block|syntax|javascript|1905732|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

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:

<pre><code>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
</code></pre>

blocks|key|1186346|text|下面是一个SP的示例，它同时返回一个表和一个返回值。我不知道你是否需要返回“返回值”，我不知道MATLAB和它需要什么。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1186347|CREATE+PROCEDURE+test
AS+
BEGIN

++++SELECT+*+FROM+sys.databases

++++RETURN+27
END

--Use+this+to+test
DECLARE+@returnval+int

EXEC+@returnval+=+test+

SELECT+@returnval|code-block|syntax|javascript|1186348|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Here's an example of a SP that both returns a table and a return value. I don't know if you need the return the "Return Value" and I have no idea about MATLAB and what it requires. 

<pre><code>CREATE PROCEDURE test
AS 
BEGIN

 SELECT * FROM sys.databases

 RETURN 27
END

--Use this to test
DECLARE @returnval int

EXEC @returnval = test 

SELECT @returnval
</code></pre>

blocks|key|1905787|text|如果要同时使用结果集和返回值，可以使用out参数而不是返回值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1905788|CREATE+PROCEDURE+proc_name+
@param+int+out
AS
BEGIN
++++SET+@param+=+value
SELECT+...+FROM+[Table]+WHERE+Condition
END
GO|code-block|syntax|javascript|1905789|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can use an out parameter instead of the return value if you want both a result set and a return value

<pre><code>CREATE PROCEDURE proc_name 
@param int out
AS
BEGIN
 SET @param = value
SELECT ... FROM [Table] WHERE Condition
END
GO
</code></pre>

blocks|key|1905845|text|存储过程返回的状态值只能是INT数据类型。不能返回返回语句中的其他数据类型。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1905846|来自第2课:设计存储过程|offset|length|1905847|每个存储过程都可以返回一个称为执行状态值的整数值或返回代码。|blockquote|style|BOLD|1905848|如果您仍然想要从SP返回的表，则必须使用SP中的SELECT返回的记录集，或者将其绑定到传递XML数据类型的输出变量中。|1905849|HTH，|1905850|约翰|1905851|entityMap|0|LINK|mutability|MUTABLE|url|http://technet.microsoft.com/en-us/library/cc505879.aspx^0|0|2|A|0|0|L|2|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@$D|10|E|11|1|12]]|A|$]]|$1|F|3|G|5|H|7|13|8|@$D|14|E|15|I|J]]|9|@]|A|$]]|$1|K|3|L|5|6|7|16|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|17|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|18|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

The Status Value being returned by a Stored Procedure can only be an INT datatype. You cannot return other datatypes in the RETURN statement.

From <a href="http://technet.microsoft.com/en-us/library/cc505879.aspx" rel="nofollow">Lesson 2: Designing Stored Procedures</a>:

<blockquote>
 Every stored procedure can return an integer value known as the
 execution status value or return code.
</blockquote>

If you still want a table returned from the SP, you'll either have to work the record set returned from a SELECT within the SP or tie into an OUTPUT variable that passes an XML datatype.

HTH,

John

blocks|key|2184675|text|考虑创建一个函数，该函数可以返回表并用于查询。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2184676|https://msdn.microsoft.com/en-us/library/ms186755.aspx|offset|length|2184677|函数与过程的主要区别在于，函数不会更改任何表。它只返回一个值。|2184678|在本例中，我创建了一个查询，以给出给定表中不为空或空的所有列的计数。|2184679|可能有很多方法来清理这件事。但它很好地说明了一个函数。|2184680|USE+Northwind

CREATE+FUNCTION+usp_listFields(@schema+VARCHAR(50),+@table+VARCHAR(50))
RETURNS+@query+TABLE+(
++++FieldName+VARCHAR(255)
++++)
BEGIN
++++INSERT+@query
++++SELECT
++++++++'SELECT+'''+%2B+@table%2B'~'%2BRTRIM(COLUMN_NAME)%2B'~''%2BCONVERT(VARCHAR,+COUNT(*))+'%2B
++++'FROM+'%2B@schema%2B'.'%2B@table%2B'+'%2B
++++++++++'+WHERE+isnull("'%2BRTRIM(COLUMN_NAME)%2B'",'''')<>''''+UNION'
++++FROM+INFORMATION_SCHEMA.COLUMNS+WHERE+TABLE_NAME+=+@table+and+TABLE_SCHEMA+=+@schema
++++RETURN
END|code-block|syntax|javascript|2184681|然后用|2184682|SELECT+*+FROM+usp_listFields('Employees')|2184683|生成若干行，如：|2184684|SELECT+'Employees~EmployeeID~'%2BCONVERT(VARCHAR,+COUNT(*))+FROM+dbo.Employees++WHERE+isnull("EmployeeID",'')<>''+UNION
SELECT+'Employees~LastName~'%2BCONVERT(VARCHAR,+COUNT(*))+FROM+dbo.Employees++WHERE+isnull("LastName",'')<>''+UNION
SELECT+'Employees~FirstName~'%2BCONVERT(VARCHAR,+COUNT(*))+FROM+dbo.Employees++WHERE+isnull("FirstName",'')<>''+UNION|2184685|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|1I|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|16|8|@]|9|@$D|17|E|18|1|19]]|A|$]]|$1|F|3|G|5|6|7|1A|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1B|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1C|8|@]|9|@]|A|$]]|$1|L|3|M|5|N|7|1D|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|1E|8|@]|9|@]|A|$]]|$1|S|3|T|5|N|7|1F|8|@]|9|@]|A|$O|P]]|$1|U|3|V|5|6|7|1G|8|@]|9|@]|A|$]]|$1|W|3|X|5|N|7|1H|8|@]|9|@]|A|$O|P]]|$1|Y|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]]|Z|$10|$5|11|12|13|A|$14|C]]]]

Consider creating a function which can return a table and be used in a query.

<a href="https://msdn.microsoft.com/en-us/library/ms186755.aspx" rel="noreferrer">https://msdn.microsoft.com/en-us/library/ms186755.aspx</a>

The main difference between a function and a procedure is that a function makes no changes to any table. It only returns a value.

In this example I'm creating a query to give me the counts of all the columns in a given table which aren't null or empty.

There are probably many ways to clean this up. But it illustrates a function well.

<pre><code>USE Northwind

CREATE FUNCTION usp_listFields(@schema VARCHAR(50), @table VARCHAR(50))
RETURNS @query TABLE (
 FieldName VARCHAR(255)
 )
BEGIN
 INSERT @query
 SELECT
 'SELECT ''' + @table+'~'+RTRIM(COLUMN_NAME)+'~''+CONVERT(VARCHAR, COUNT(*)) '+
 'FROM '+@schema+'.'+@table+' '+
 ' WHERE isnull("'+RTRIM(COLUMN_NAME)+'",'''')&lt;&gt;'''' UNION'
 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = @table and TABLE_SCHEMA = @schema
 RETURN
END
</code></pre>

Then executing the function with 

<pre><code>SELECT * FROM usp_listFields('Employees')
</code></pre>

produces a number of rows like:

<pre><code>SELECT 'Employees~EmployeeID~'+CONVERT(VARCHAR, COUNT(*)) FROM dbo.Employees WHERE isnull("EmployeeID",'')&lt;&gt;'' UNION
SELECT 'Employees~LastName~'+CONVERT(VARCHAR, COUNT(*)) FROM dbo.Employees WHERE isnull("LastName",'')&lt;&gt;'' UNION
SELECT 'Employees~FirstName~'+CONVERT(VARCHAR, COUNT(*)) FROM dbo.Employees WHERE isnull("FirstName",'')&lt;&gt;'' UNION
</code></pre>

blocks|key|1186482|text|我遇到了类似的情况，并通过在过程中使用临时表来解决问题，原始存储过程返回相同的字段：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1186483|CREATE+PROCEDURE+mynewstoredprocedure
AS+
BEGIN

INSERT+INTO+temptable+(field1,+field2)
EXEC+mystoredprocedure+@param1,+@param2

select+field1,+field2+from+temptable

--+(mystoredprocedure+returns+field1,+field2)

END|code-block|syntax|javascript|1186484|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I had a similar situation and solved by using a temp table inside the procedure, with the same fields being returned by the original Stored Procedure:

<pre><code>CREATE PROCEDURE mynewstoredprocedure
AS 
BEGIN

INSERT INTO temptable (field1, field2)
EXEC mystoredprocedure @param1, @param2

select field1, field2 from temptable

-- (mystoredprocedure returns field1, field2)

END
</code></pre>

blocks|key|2184737|text|create+procedure+PSaleCForms
as
begin
declare+
@b+varchar(9),
@c+nvarchar(500),
@q+nvarchar(max)
declare+@T+table(FY+nvarchar(9),Qtr+int,title+nvarchar++++(max),invoicenumber+++++nvarchar(max),invoicedate+datetime,sp+decimal++++18,2),grandtotal+decimal(18,2))
declare+@data+cursor
set+@data=+Cursor
forward_only+static
for+
select+x.DBTitle,y.CurrentFinancialYear+from+[Accounts+++++Manager].dbo.DBManager+x+inner+join+[Accounts+Manager].dbo.Accounts+y+on++++++++y.DBID=x.DBID+where+x.cfy=1
open+@data
fetch+next+from+@data
into+@c,@b
while+@@FETCH_STATUS=0
begin
set+@q=N'Select+'''%2B@b%2B'''+[fy],+case+cast(month(i.invoicedate)/3.1+as+int)+++++when+0+then+4+else+cast(month(i.invoicedate)/3.1+as+int)+end+[Qtr],+++++l.title,i.invoicenumber,i.invoicedate,i.sp,i.grandtotal+from+++++['%2B@c%2B'].dbo.invoicemain+i+inner+join++['%2B@c%2B'].dbo.ledgermain+l+on+++++l.ledgerid=i.ledgerid+where+(sp=0+or+stocktype=''x'')+and+invoicetype=''DS'''|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|2184738|插入到@T+exec+master.dbo.sp_executesql+@q下一步从@数据取到@c，@b结束关闭@数据释放@数据选择*从@T返回端|unstyled|2184739|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>create procedure PSaleCForms
as
begin
declare 
@b varchar(9),
@c nvarchar(500),
@q nvarchar(max)
declare @T table(FY nvarchar(9),Qtr int,title nvarchar (max),invoicenumber nvarchar(max),invoicedate datetime,sp decimal 18,2),grandtotal decimal(18,2))
declare @data cursor
set @data= Cursor
forward_only static
for 
select x.DBTitle,y.CurrentFinancialYear from [Accounts Manager].dbo.DBManager x inner join [Accounts Manager].dbo.Accounts y on y.DBID=x.DBID where x.cfy=1
open @data
fetch next from @data
into @c,@b
while @@FETCH_STATUS=0
begin
set @q=N'Select '''+@b+''' [fy], case cast(month(i.invoicedate)/3.1 as int) when 0 then 4 else cast(month(i.invoicedate)/3.1 as int) end [Qtr], l.title,i.invoicenumber,i.invoicedate,i.sp,i.grandtotal from ['+@c+'].dbo.invoicemain i inner join ['+@c+'].dbo.ledgermain l on l.ledgerid=i.ledgerid where (sp=0 or stocktype=''x'') and invoicetype=''DS'''
</code></pre>

insert into @T exec [master].dbo.sp_executesql @q
fetch next from @data
into @c,@b
end
close @data
deallocate @data
select * from @T
return
end

blocks|key|2184773|text|我经常使用表类型来确保更多的一致性和简化代码。技术上您不能返回“一个表”，但是您可以返回一个结果集并使用INSERT+INTO+..+EXEC+...语法，您可以清楚地调用PROC并将结果存储到一个表类型中。在下面的示例中，我实际上是将一个表与另一个需要添加逻辑的param一起传递到PROC中，然后我实际上是在“返回一个表”，然后可以将它作为一个表变量处理。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2184774|/******+Check+if+my+table+type+and/or+proc+exists+and+drop+them+******/
IF+EXISTS+(SELECT+*+FROM+sys.objects+WHERE+type+=+'P'+AND+name+=+'returnTableTypeData')
DROP+PROCEDURE+returnTableTypeData
GO
IF+EXISTS+(SELECT+*+FROM+sys.types+WHERE+is_table_type+=+1+AND+name+=+'myTableType')
DROP+TYPE+myTableType
GO

/******+Create+the+type+that+I'll+pass+into+the+proc+and+return+from+it+******/
CREATE+TYPE+[dbo].[myTableType]+AS+TABLE(
++++[someInt]+[int]+NULL,
++++[somenVarChar]+[nvarchar](100)+NULL
)
GO

CREATE+PROC+returnTableTypeData
++++@someInputInt+INT,
++++@myInputTable+myTableType+READONLY+--Must+be+readonly+because
AS
BEGIN

++++--Return+the+subset+of+data+consistent+with+the+type
++++SELECT
++++++++*
++++FROM
++++++++@myInputTable
++++WHERE
++++++++someInt+<+@someInputInt

END
GO


DECLARE+@myInputTableOrig+myTableType
DECLARE+@myUpdatedTable+myTableType

INSERT+INTO+@myInputTableOrig+(+someInt,somenVarChar+)
VALUES+(+0,+N'Value+0'+),+(+1,+N'Value+1'+),+(+2,+N'Value+2'+)

INSERT+INTO+@myUpdatedTable+EXEC+returnTableTypeData+@someInputInt=1,+@myInputTable=@myInputTableOrig

SELECT+*+FROM+@myUpdatedTable


DROP+PROCEDURE+returnTableTypeData
GO
DROP+TYPE+myTableType
GO|code-block|syntax|javascript|2184775|entityMap^0|1G|N|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

I do this frequently using Table Types to ensure more consistency and simplify code. You can't technically return "a table", but you can return a result set and using <code>INSERT INTO .. EXEC ...</code> syntax, you can clearly call a PROC and store the results into a table type. In the following example I'm actually passing a table into a PROC along with another param I need to add logic, then I'm effectively "returning a table" and can then work with that as a table variable.

<pre><code>/****** Check if my table type and/or proc exists and drop them ******/
IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'returnTableTypeData')
DROP PROCEDURE returnTableTypeData
GO
IF EXISTS (SELECT * FROM sys.types WHERE is_table_type = 1 AND name = 'myTableType')
DROP TYPE myTableType
GO

/****** Create the type that I'll pass into the proc and return from it ******/
CREATE TYPE [dbo].[myTableType] AS TABLE(
 [someInt] [int] NULL,
 [somenVarChar] [nvarchar](100) NULL
)
GO

CREATE PROC returnTableTypeData
 @someInputInt INT,
 @myInputTable myTableType READONLY --Must be readonly because
AS
BEGIN

 --Return the subset of data consistent with the type
 SELECT
 *
 FROM
 @myInputTable
 WHERE
 someInt &lt; @someInputInt

END
GO


DECLARE @myInputTableOrig myTableType
DECLARE @myUpdatedTable myTableType

INSERT INTO @myInputTableOrig ( someInt,somenVarChar )
VALUES ( 0, N'Value 0' ), ( 1, N'Value 1' ), ( 2, N'Value 2' )

INSERT INTO @myUpdatedTable EXEC returnTableTypeData @someInputInt=1, @myInputTable=@myInputTableOrig

SELECT * FROM @myUpdatedTable


DROP PROCEDURE returnTableTypeData
GO
DROP TYPE myTableType
GO
</code></pre>

blocks|key|1186598|text|虽然这个问题很老，但作为软件开发中的一个新问题，我无法停止自我分享我学到的东西。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1186599|存储过程的创建：|offset|length|style|BOLD|1186600|CREAET+PROC+usp_ValidateUSer
(
++++@UserName+nVARCHAR(50),
++++@Password+nVARCHAR(50)
)
AS

BEGIN
++++IF+EXISTS(SELECT+'#'+FROM+Users+WHERE+Username=@UserName+AND+Password=@Password)
++++BEGIN
++++++++SELECT+u.UserId,+u.Username,+r.UserRole
++++++++FROM+Users+u
++++++++INNER+JOIN+UserRoles+r
++++++++ON+u.UserRoleId=r.UserRoleId
++++END
END|code-block|syntax|javascript|1186601|存储过程的执行：|1186602|(如果要在SQL中测试存储过程的执行情况)|1186603|EXEC+usp_ValidateUSer+@UserName='admin',+@Password='admin'|1186604|Th输出：|1186605|​|1186606|📷|atomic|1186607|1186608|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/4e5226154ec0a75439f920f242892182.png|imageAlt^0|0|5|3|0|0|5|3|0|0|0|0|5|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@$D|1B|E|1C|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|1D|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|1E|8|@$D|1F|E|1G|F|G]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Q|3|R|5|J|7|1I|8|@]|9|@]|A|$K|L]]|$1|S|3|T|5|6|7|1J|8|@$D|1K|E|1L|F|G]]|9|@]|A|$]]|$1|U|3|V|5|6|7|1M|8|@]|9|@]|A|$]]|$1|W|3|X|5|Y|7|1N|8|@]|9|@$D|1O|E|1P|1|1Q]]|A|$]]|$1|Z|3|V|5|6|7|1R|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17|18|-4]]]]

Though this question is very old but as a new in Software Development I can't stop my self to share what I have learnt :D

Creation of Stored Procedure:

<pre><code>CREAET PROC usp_ValidateUSer
(
 @UserName nVARCHAR(50),
 @Password nVARCHAR(50)
)
AS

BEGIN
 IF EXISTS(SELECT '#' FROM Users WHERE Username=@UserName AND Password=@Password)
 BEGIN
 SELECT u.UserId, u.Username, r.UserRole
 FROM Users u
 INNER JOIN UserRoles r
 ON u.UserRoleId=r.UserRoleId
 END
END
</code></pre>

Execution of Stored Procedure:

(If you want to test the execution of Stored Procedure in SQL)

<pre><code>EXEC usp_ValidateUSer @UserName='admin', @Password='admin'
</code></pre>

Th Output:

<a href="https://i.stack.imgur.com/JhQR4.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JhQR4.png" alt="enter image description here"></a>

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.

It has added this line,

<pre><code> SELECT 'Return Value' = @return_value
</code></pre>

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.

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)?

SQL server stored procedure return a table

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个存储过程，它接受两个参数。我可以在中成功地执行它。它向我展示了我所期望的结果。但是，它也返回一个返回值。它增加了这一行， SELECT 'Return Value' = @return_value我希望存储过程返回它在结果中显示的表，而不是返回值，因为我从MATLAB调用这个存储过程，它返回的全部是true或f...

问SQL server存储过程返回表。
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL server存储过程返回表。EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问SQL server存储过程返回表。
EN