|
| Retrieve MSSQL stored procedure |
| Iniciado por JOHNKEN, 20,feb. 2021 08:15 - 1 respuesta |
| |
| | | |
|
| |
Miembro registrado
26 mensajes |
|
| Publicado el 20,febrero 2021 - 08:15 |
Hi,
Anyone tried retrieving output of MSSQL stored procedure with 2 different result
here is the sample of stored procedure
ALTER PROCEDURE [dbo].[spTest]
(@pVal1 INT = 0)
AS
BEGIN
SET NOCOUNT ON;
IF @pVal1 = 0
BEGIN
SELECT 'two columns' AS COL1, 'COL2' AS COL2
END
ELSE
BEGIN
SELECT 'one column only' AS COL1
END
END
But when i make the sp like this i can retrieve this
ALTER PROCEDURE [dbo].[spTestOK]
(@pVal1 INT = 0)
AS
BEGIN
SET NOCOUNT ON;
IF @pVal1 = 0
BEGIN
SELECT 'two columns' AS COL1, 'COL2' AS COL2
END
ELSE
BEGIN
SELECT 'one column only' AS COL1, 'COL2' AS COL2
END
END
Im using WD25 and SQL Native Driver |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
26 mensajes |
|
| Publicado el 20,febrero 2021 - 08:56 |
| |
| |
| | | |
|
| | | | |
| | |
|