Autimatic Stored Proc Generation

  • Thread starter Thread starter A.M
  • Start date Start date
A

A.M

Hi,

Is there any automatic stored procedure generator to generate up_insert,up_
update, up_delete stored procedures for a table?

Thanks,
Ali
 
Thanks for the community response!

Hi Ali,

Thank you for posting in the community!

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to get a tool that can
generate insert, update and delete stored procedures automatically for you.
If there is any misunderstanding, please feel free to let me know.

In the last two posts, we have got two good links for such tools that can
generate the stored procedures automatically. Besides these, if you are
working on Visual Studio .NET and using ADO.NET, we can also use the
DataAdapter wizard to generate it.

Here are the steps:
1. Drag a SqlDataAdapter control to the form.
2. Select a connection to the data source. Click Next.
3. Select Createnewstoredprocedures. Click Next.
4. Use Query Builder to create the SELECT command. Click Next.
5. Name the SELECT, UPDATE, INSERT and DELETE stored procedure. Click Next.
6. The wizard will generate the UPDATE, INSERT and DELETE command according
to SELECT command. Click Finish.

HTH. Does this answer your question? If anything is unclear, please feel
free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Back
Top