RE: Autimatic Stored Proc Generation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 03/11/04 

Date: Thu, 11 Mar 2004 02:42:01 GMT

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."

Relevant Pages

  • Re: Force mount with HPUX 11.00 when Block Read Error
    ... posting I was able to mount the volume using '-F hfs -f' as you said. ... I just wonder why I couldn't find your forum response using google, ... > but that does not seem to work anymore. ... >> command usage help of the mount command. ...
    (comp.sys.hp.hpux)
  • Re: subinacl to remove unknown sids
    ... If 2008 run the command prompt, even with the administrator account, with "run as". ... Meinolf Weber ... Disclaimer: This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.windows.server.active_directory)
  • RE: migrate profile
    ... I recommend that you try a Windows 2000 Server Resource Kit tool, ... You can use the following command. ... "moveuser UserAAA DomainName\UserBBB /k" ... This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.windows.server.migration)
  • Re: "lobert" can u answer this
    ... My posting is considered ... Trouble maker like u is not worth listening to. ... Even skipping over his immediate command ... If u r a nobody in the army, ur complain ...
    (soc.culture.singapore)
  • Re: Need help with Stored Procedures being called from Client Code.
    ... Although I totally advocate the use of Stored Procs for many reasons, ... Performance and Security aren't a slam dunk with procs - you can do the same ... you need to set a command for each operation that you are ... > I created the stored procedures for Select, Insert, Update and Delete ...
    (microsoft.public.dotnet.framework.adonet)