对存储过程的怀疑 [英] Doubt in Stored Procedure

问题描述

大家好，

我有一个包含两个查询的存储过程，执行时返回多个行.第二个查询取决于第一个查询的输出.所以我想将第一个查询(包含多个行)的结果存储在过程本身中并使用它在第二个查询中.存储过程中是否有任何东西可以在前端存储"DataSet"之类的结果?

如果是，请告诉我或指导我如何做.

谢谢....

Hi every one,

I have a Stored Procedure that contains two queries, those returns multiple rows when executed.The 2st query depends on the output of 1st query.So i want to store the result of 1st query(that contains multiple rows)in procedure itself and use it in 2nd query.Is there any thing in stored procedure to store the result like "DataSet" in frontend?

If yes please tell me about it or guide me how to do this.

Thanks....

推荐答案

您可以嵌套查询:

You can nest queries:

SELECT TOP 5 * FROM [myDatabase].[dbo].[Customers] WHERE ID IN 
  (
   SELECT ID FROM [myDatabase].[dbo].[Customers] WHERE ID > 5 
   EXCEPT
   SELECT iD FROM [myDatabase].[dbo].[Customers] WHERE ID < 10
  )

或创建临时表: SQL –临时表 [ ^ ]或MSDN [ ^ ]

Or create temporary tables: SQL – Temporary Tables[^] or MSDN[^]

这篇关于对存储过程的怀疑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！