Teradata Forums / Teradata / Teradata Tools and Utilities / Differences between Macro and Stored procedue / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 21 Nov 2009 19:07:21 GMT20RE: Differences between Macro and Stored proceduehttp://www.teradata.com/teradataforum/Topic15931-10-1.aspxHello,Following are few differences between MACRO and Stored-Procedure:MACRO:- Limited procedural logic- Can return multi row answer sets for the same request- Multi-statement request parallelizes multiple single row statements- Can EXPLAIN a macro- Can be invoked by a triggerStored Procedure- Sophisticated procedural logic - Returns a single set of values (Before Teradata 12)- One request per individually processed statement- Cannot EXPLAIN a stored procedure. Instead, must EXPLAIN each individual stored procedure SQL statement individually- Cannot be invoked by a triggerHTH!Regards,AdeelSun, 28 Jun 2009 23:15:18 GMTAdeel.ChaudhryDifferences between Macro and Stored proceduehttp://www.teradata.com/teradataforum/Topic15931-10-1.aspxHi,Can any one please tell me the differences between a Macro and Stored procedue as both contains set of sql statements.Regards,kiranFri, 26 Jun 2009 15:41:18 GMTkiran parsha