Stored procedure in MS SQL server 2008

[Former Member]

hi,

I have a scenario JDBC to file.at sender JDBC i need to select from two different tables and update multiple tables.So i'm going for stored procedure option here.DB is MS SQL server 2008.

I have read few threads on this .

" SP call works with SQL Server 2005 as well, the SP call should be "execute SPNAME <paramas>". "

How does it return ROW format in case of MS SQL server?is it same as oracle DB?

[MichalKrawczyk]

Hi,

SQL procedure should have one select statement and it will return the values in the resultset

as per example below:

http://help.sap.com/saphelp_nw73/helpdata/en/7E/5DF96381EC72468A00815DD80F8B63/frameset.htm

Regards,

Michal Krawczyk