存储过程输出没有给出值..只给出列名..如何解决这个问题 [英] Store procedure output not give value..it give just Column names.. how solve this problem

问题描述

CREATE PROCEDURE [dbo].[SP_GETDEVMASTERBYDNUM]
(
@DEVICE_NO nvarchar(6)
)
AS
	SET NOCOUNT ON;
SELECT tbdm.SERIAL_NO, tbdm.DEVICE_NO, tbdm.MODELCODE, tbdm.PONO, tbdm.STCODE, tbdm.REMARKS, tbdm.PROCESSOR, tbdm.RAM, tbdm.HARDDISK, tbdm.DEVCODE, tbdm.DEPCODE, tbdm.FLG_TYPE, tbdm.SLNO, tbpo.POEHDATE
FROM TBL_DEVMASTER tbdm
INNER JOIN TBL_PURCHASE tbpo ON tbdm.PONO = tbpo.PONO
WHERE  (DEVICE_NO=@DEVICE_NO)

输出：

OUTPUT:

Running [dbo].[SP_GETDEVMASTERBYDNUM] ( @DEVICE_NO = c200 ).

SERIAL_NO                      DEVICE_NO MODELCODE                                                                                                                                                                                                                                                        PONO                      STCODE                                                                                                                                                                                                                                                           REMARKS                                                                                              PROCESSOR  RAM        HARDDISK   DEVCODE                                                                                                                                                                                                                                                          DEPCODE                                                                                                                                                                                                                                                          FLG_TYPE                                                                                                                                                                                                                                                         SLNO                                                                                                                                                                                                                                                             POEHDATE   
--------------- ---------- 
No rows affected.
(0 row(s) returned)
@RETURN_VALUE = 0
Finished running [dbo].[SP_GETDEVMASTERBYDNUM].

删除了SHOUTING，添加了代码块 - OriginalGriff [/ edit]

[edit]SHOUTING removed, Code block added - OriginalGriff[/edit]

推荐答案

为什么SP不显示任何行？简单！



DEVICE_NO列值与@DEVICE_NO参数传递的值不匹配。



检查您调用它的代码，或检查您的数据。问题出在那里。

Why does you SP not show any rows? Simple!

There are no rows where the DEVICE_NO column value matches the value you have passed in as the @DEVICE_NO parameter.

Check the code from which you call it, or check your data. The problem is there.

这篇关于存储过程输出没有给出值..只给出列名..如何解决这个问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！