INSERT STORED PROCEDURE

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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

Stored Procedure in SQL Server 2000 ? 1
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
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Running stored procedure that has default values 2
Re: Parameter size for NVARCHAR(MAX) data type? 0
SQL Update/Insert using SqlDataAdapter and Stored Procedure 1

Back
Top