How to execute multiple queries in one stored procedure.

Hi,

I am Kumar,

here is the my requirements,

1. get the max value from one table and sum of the that value.

2. insert the values and also sum of the max value.

using stored procedure

I am using SQL server 2000 database.

Please help me.

Advance thanks

by,

Kumar

[390 byte] By [ksenthilkumara] at [2007-11-27 10:57:49]

«« setting Action Method as POST in Javascript
»» Using apache StringUtils and DbUtils

# 1

This is not a java question and it is not even a problem: your only problem is

1) lack of knowledge

2) lack of interest to find a manual

But you are going to have to change both by actually reading a book or a manual that explains the stored procedure language of SQL Server. It is the same as Sybase I think, so you could also look for a manual for that DBMS.

gimbal2a at 2007-7-29 12:11:33 >

top of Java-index,Java Essentials,Java Programming...

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

How to execute multiple queries in one stored procedure.

Java Essentials New Topic

Java Essentials Hot Topic

Java Essentials

All Classified