WHERE can I find...

[Guest_imported]

I'm an application designer with a cobol background. Now I'm designing a system witch uses VB, VBscript, asp, advanced server and sequal server technologies.

The programmers are talking about stored procedures and triggers. And a lot of solutions (witch are no problem in cobol) are not possible or will take a lot time.
I want to know why.

So if anybody has any hints or links to learn someting about the stored procedures and triggers, I'm eager to know!

So no technical details, but more about the architecture, the possibilitys and shortcomings.

Thank you in advance,

Karel van Dingen
application designer sr.
CMG - Netherlands

 

[tapks]

Karel!

Pl visit this URL

http://www.mssqlserver.com/tsql/

. U can down load 'All Units' & just go through it. Definitely you will have some ideas on it.

 

[Guest_imported]

tapks,

Thank you for your reply, MS SQL server uses the same method as IBM DB2 (I'm an expert in db2), until I reached Unit 14 (last chapter). There was something about Stored Procedures.

Tell me if I'm right:

A Stored Procedure is nothing more than a batch of sql-statements, witch can be called by programmes. Stored procedures can call other stored procedures (YES, let's make a mess).

So, a stored procedure has a linkage section and is nothing more than a module witch can be called by a programm after filling the linkage area with the right values (Filling the WHERE clause).

So, a S.P. is a SQL statement.

SO, EVERYTHING IS POSSIBLE, IF V.B. CAN HANDLE IT??