我需要查阅在一份声明中储存的程序的结果,即:
SELECT * FROM [dbo].[sp_sample]
页: 1
https://stackoverflow.com/questions/2515955/using-stored-procedure-into-select-t-sql/2515996#2515996>@Barry is right 你们需要首先制定一张温床,然后在你选择时加入这个表。
然而,在储存程序之间分享数据有多种方法,见这一极好的条款:。 如何分享Ermland Sommarskog所储存的程序之间的数据
一种可能为你工作的方法是“分享”一种温床。 该表是在父母程序中设立的,可由儿童使用:。 http://www.sommarskog.se/comm_data.html#temptables。
这是可能的。 你们必须设立一个临时表格,储存成果。
Create Table #tmp
(
...
)
Insert into #tmp
Exec dbo.StoredProcedure
表格结构必须与储存程序的产出相匹配。
I ve got two tables: TableA Col1 Col2 TableB Col3 Col4 I want to join them together: SELECT * from TableA join TableB ON (...) Now, in place of ... I need to write an expression ...
TSQL query to select all records from Customer that has an Order and also select all records from customer that does not have an Order. The table Customer contains a primary key of CustomerID. The ...
I have a stored procedure which takes an XML parameter and inserts the data into multiple tables. If I run the stored procedure into a database using a SSMS query window, everything works fine. ...
Have a win 2003 box with MSSQL 2005 running on it. There is a database which is populated every morning with new/modified SalesOrder made the previous day. The database has several tables: SalesOrder, ...
I have a table with the following fields Id Name IsPublic i need to write a sql query that updates IsPublic to false where name has a duplicate. Only one of the duplicates should have IsPublic = ...
I have a Transact-SQL query that uses the IN operator. Something like this: select * from myTable where myColumn in (1,2,3,4) Is there a way to define a variable to hold the entire list "(1,2,3,4)"? ...
I ve got a content management system that contains a hierarchical structure of categories, with sub-categories subject to different ordering options at each level. Currently, that s retrieved by a (...
I m trying to transform the SQL Query below into Linq to SQL select Categorias.IdCategoria, Categorias.Nome, SUM(lancamentos.valor) from lancamentos left outer join Categorias on Lancamentos....