How to capture Output of SQL queries and

Question

I have a Database and i want to execute few queries on it, and the results of the queries i.e. message, has to be comapared in my code if it is expected or not. Please let me know how to capture the output of the SQL queries in any variable that can be used later in code for comparision.

Maybe this will help you . stackoverflow.com/questions/37552995/… — Adi
– Adi, Commented Apr 25, 2018 at 6:08

Jayasurya Satheesh · Accepted Answer · 2018-04-25 06:11:05Z

0

Try the following Method :

Create a Table with the Same structure as of your Procedure output
Insert the Result of the SP Execution to the Table
Compare your Query result with the Table

Like this

CREATE PROCEDURE dbo.uSp_Temp
AS
SELECT
    GETDATE() "MyDate"

DECLARE @T TABLE
(
    MyDate DATE
)

INSERT INTO @T
EXEC uSp_Temp

SELECT
    *
    FROM @T

answered Apr 25, 2018 at 6:11

Jayasurya Satheesh

8,0733 gold badges25 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

SQLHelp · Accepted Answer · 2018-04-25 06:12:10Z

0

You can use Temp tables or temp variable to save the result set of a query.

Below is the sample for temp table

create table #temp (id int)

insert into #temp 
select 1 as id

select * from #temp

Below is sample for Temp variable

declare  @temp table (id int)

insert into @temp 
select 1 as id

select * from @temp

answered Apr 25, 2018 at 6:12

SQLHelp

414 bronze badges

Collectives™ on Stack Overflow

How to capture Output of SQL queries and

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related