Answer the question
In order to leave comments, you need to log in
How to change the return data of a procedure?
I use a certain helper in sharp which takes the returned data of procedure. The point is that in the procedure you simply specify
select 0
return
select 1
select 0
return
Answer the question
In order to leave comments, you need to log in
1. In C#, you can read multiple datasets using SqlDataReader.NextResult()
2. Getting a dataset when calling HP:
CREATE TABLE #T (
V INT
)
INSERT INTO #T(V) EXEC MyProc
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question