INSERT STORED PROCEDURE

G

Guest

Hi,

Can anybody give me a sample code / sql script to write a very good INSERT
INTO TABLE STORED PROCEDURE
1. It should take values from the client application which i should be able
to pass as parameters

2. it should take exception handling

bye
ss
 
C

Cor Ligthert [MVP]

ss,

The stored procedure is not different from the normal procedure with the
exception that you make in advance a declaration.

See my answer on your other message.

Cor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User with privilege on a stored procedure in SQL Server 2000 / 200 4
stored procedure select statement with where clause 4
Database with right Privileges & ADO.NET (ASP.NET Application) 2
Stored Procedure in SQL Server 2000 ? 1
Running stored procedure that has default values 2
Replacing stored procedure 5
compiler error during scripting Oracle stored procedure 1
Sending a set of data to a stored procedure 3

Top