Result Sets and output parameters are not the same.
Result Set
ResultSets are used to store a
result of a Select query: It can be a one or more columns and it can be a
single row or a full result set or XML. ResultSets are retrieved as ADO
ResultSets and can be stored within variables. It may be
It is in General tab.
None: Insert, update,
delete, create, drop or truncate
Single Row: store the
single row only
Full result set: stored
full result. Data type will be the object type variable.
XML: to store the XML type
records.
Output Parameters or return value
Output Parameters are used to
store some values that can be set any part of the SQL command. Parameters have
the same concept of a SQL stored procedure parameters.
We will get it in the parameter
mapping
Read more about:
Enjoyed reading the article above, really explains everything in detail, the article is very interesting and effective. Thank you and good luck for the upcoming articles LearnMsbi online training
ReplyDeleteEnjoyed reading the article above, really explains everything in detail, the article is very interesting and effective. Thank you and good luck for the upcoming articles LearnMsbi online training
ReplyDeleteYou should be a part of a contest for one of the highest quality sites on the net. I’m going to highly recommend this blog! The training and certification courses to get trained on microtek training. I got really cleared my doubts by reading your informative information.
ReplyDeleteYou should be a part of a contest for one of the highest quality sites on the net. I’m going to highly recommend this blog! The training and certification courses to get trained on microtek training. I got really cleared my doubts by reading your informative information.
ReplyDeleteWell i also founded something interesting over here in microtek training solutions
Too Good article,Thank you for sharing such an amazing information.
ReplyDeleteKeep updating..
MSBI Training
MuleSoft training
ReplyDeleteMuleSoft online training
Great Article Artificial Intelligence Projects
ReplyDeleteProject Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai Project Centers in Chennai
Niche Inspectors Online Coupons and Content Discoverer Online Coupons Codes is a game changer, the deals are amazing and unbeatable. It is my go-to destination for savings.
ReplyDelete