我有一个存储过程,如下所示,我希望将其结果导出到一个表中。
DECLARE
@ReportYearCmd VARCHAR(1000),
@CosCountCmd VARCHAR(1000),
@FranchiseCountCmd AS VARCHAR(1000),
@ProductCountCmd AS VARCHAR(1000);
WITH Validations AS (
SELECT TOP 1 * FROM [Handshake] WHERE [Status] = 'Loaded' AND [Update Time] = ( S
DROP PROCEDURE `uuu`//
CREATE DEFINER=`auth_tracker`@`%` PROCEDURE `uuu`()
BEGIN
DECLARE a,b CHAR(50);
DECLARE _output TEXT DEFAULT '';
DECLARE cur1 CURSOR FOR SELECT attribute_name, value
FROM user_product_attribute upa, product_attribute pa
WHERE upa.user_product_id IN
( SELE
"select tableshow from alltable where branch =
'"+session.getAttribute("Branch")+"' and sem =
'"+session.getAttribute("Sem")+"'";
通过这个查询,我获取了表的名称,例如,假设表名为'fifthsem‘,它存储在exe变量中
现在我需要在这个变量exe上应用查询作为表名。我需要从这个表的过程中获取全部数据,并在jsp页面中显示。
使
我有一个名为Sp_Ejecucion的存储过程,它创建了一个具有以下结构的临时表:
CREATE TABLE #CambioResult (FOL INT IDENTITY, RESULT INT)
在该命令之后运行另一个Sp,如下所示
BEGIN TRAN T1
DECLARE @vnCambiaRollTurnoResult INT = 0,
@vnReacomodoMarcajesResult INT = 0,
@Result INT = 0
BEGIN TRY
exec nsp_Exec
我尝试在单引号内创建一个临时表,它显示错误,它无法识别表#newtable...它只支持##table (全局临时表),但我不想要一个全局临时表,我只想知道谁解释它背后的原因。
select
column1, column2, column3, ##newtable.columnid as ShipProfile,
row_number() over (order by Id) as ''RowNumber''
into
##TempProduct
from
Product
left join
我使用的是SQL Server2005,我想知道如何从transact-sql中访问不同的结果集。下面的存储过程返回两个结果集,例如,我如何从另一个存储过程访问它们?
CREATE PROCEDURE getOrder (@orderId as numeric) AS
BEGIN
select order_address, order_number from order_table where order_id = @orderId
select item, number_of_items, cost from order_line where order_id = @o