显示存储过程值 [英] Display stored procedure value

问题描述

我有以下SQL代码，一切都没有错误，但我不明白的是我怎样才能显示返回的值？谢谢。例如。我想显示SalesOrder。以下是我的代码，

  ALTER   PROCEDURE  [dbo]。[usp_SalesOrderForUnit_Select] 
  @ UnitID   BigInt  
  AS  
  BEGIN  
  SELECT   DISTINCT  
 so.Number  as  SalesOrder 
 ，sog.Number  as  SalesOrderGroup 
，so.NumberPurchaseOrder  as  PurchaseOrder 
  FROM  
   -    UnitSetup.UnitDetail AS ud  
   -    INNER JOIN ProductionControl.ContainerContent cc  
   -    ON ud.UnitHeaderId = cc.UnitHeaderId  
   -   和cc.DateEffectiveOut ='99991231 23：59：59.999' 
   -  -    INNER JOIN UnitSetup.SalesOrderGroupVersion AS sogv  
   -    ON sogv.SalesOrderGroupVersionId = cc.SalesOrderGroupVersionId  
   -    INNER JOIN UnitSetup.SalesOrderGroup AS sog  
   -    ON sog.SalesOrderGroupId = sogv.SalesOrderGroupId  
   -    INNER JOIN UnitSetup.SalesOrder AS so  
   -    ON so.Sales OrderId = sog.SalesOrderId  
 
 UnitSetup.UnitIdentity  AS  ui 
  INNER   JOIN  UnitSetup.SalesOrder  AS 所以
  ON  ui.SalesOrderId = so.SalesOrderId 
  AND  ui.DateEffectiveOut = CAST（ '  99991231 23：59：59.999'  AS  DATETIME2（ 3 ））
  INNER   JOIN  UnitSetup.SalesOrderGroupVersion  AS  sogv 
  ON  sogv.SalesOrderGroupVersionId = ui.SalesOrderGroupVersionId 
  INNER   JOIN  UnitSetup.Sal esOrderGroup  AS  sog 
  ON  sog.SalesOrderGroupId = sogv.SalesOrderGroupId 
  AND  sog.SalesOrderId = so.SalesOrderId 
 
  WHERE  
 ui.UnitHeaderId =  @ UnitID  
 
  END  

解决方案

好​​像你可能设置了查询选项网格属性



执行后丢弃结果为真，



请禁用它并尝试。< /大>

Hi, I have the below SQL codes, all is error free but on thing I dont understand is how can I make the returned values to be displayed? Thank you. E.g. I want to display SalesOrder. Below are my codes,

ALTER PROCEDURE [dbo].[usp_SalesOrderForUnit_Select]
      @UnitID BigInt
AS 
BEGIN 
    SELECT DISTINCT
            so.Number as SalesOrder
         ,sog.Number as SalesOrderGroup
         ,so.NumberPurchaseOrder as PurchaseOrder
      FROM
      --    UnitSetup.UnitDetail AS ud
      --INNER JOIN ProductionControl.ContainerContent cc
      --    ON ud.UnitHeaderId = cc.UnitHeaderId
      --    AND cc.DateEffectiveOut = '99991231 23:59:59.999'
     --INNER JOIN UnitSetup.SalesOrderGroupVersion AS sogv
      --    ON sogv.SalesOrderGroupVersionId = cc.SalesOrderGroupVersionId
      --INNER JOIN UnitSetup.SalesOrderGroup AS sog
      --    ON sog.SalesOrderGroupId = sogv.SalesOrderGroupId
      --INNER JOIN UnitSetup.SalesOrder AS so
      --    ON so.SalesOrderId = sog.SalesOrderId
      
            UnitSetup.UnitIdentity AS ui
      INNER JOIN UnitSetup.SalesOrder     AS so
            ON ui.SalesOrderId=so.SalesOrderId
            AND ui.DateEffectiveOut=CAST('99991231 23:59:59.999' AS DATETIME2(3))
      INNER JOIN UnitSetup.SalesOrderGroupVersion AS sogv
            ON sogv.SalesOrderGroupVersionId=ui.SalesOrderGroupVersionId
      INNER JOIN UnitSetup.SalesOrderGroup AS sog     
            ON sog.SalesOrderGroupId=sogv.SalesOrderGroupId
            AND sog.SalesOrderId=so.SalesOrderId

      WHERE
            ui.UnitHeaderId = @UnitID
      
END

解决方案

Hi,

it seem like you might have set query options grid property

"Discard result after execution" to true,

please disable it and try.

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