Simple Best Practice Question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Marek (Marek_at_discussions.microsoft.com)
Date: 10/19/04


Date: Tue, 19 Oct 2004 06:29:02 -0700

Hi,

I am looking for advice on best practice with SQL 2000. I have created a
fairly simple database - about 12 tables. I am unsure about the best way to
build the front end - it is going to be web based. Do I use asp.net code to
create, edit and delete records or do I use stored procedures?? I have
created 12 stored procedures for new records but an unsure on the best way to
handle edits and deletes.

-- 
Many thanks in advance for any assistance


Relevant Pages

  • Re: Single database transaction across a multiple HTTP requests?
    ... present a page to edit values BUT WITH THE ORIGINAL VALUES IN HIDDEN ... When the user submits the form, if any of the database ... >A DBA said that I should avoid transactions that are open while waiting ... >stored procedures, I'm not sure how I can do that. ...
    (comp.lang.php)
  • Stored procedures problem
    ... I get the following error when trying to edit my stored procedures ... "The database item you selected has been modified or deleted. ... refrsh the project now?" ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Simple Best Practice Question
    ... I am unsure how to go about this. ... > In short the answer is Stored Procedures ... edit and delete records or do I use stored procedures?? ... >> Many thanks in advance for any assistance ...
    (microsoft.public.sqlserver.programming)
  • Re: Stored procedures problem
    ... > I get the following error when trying to edit my stored procedures ... Open Database your.dbc Exclusive ... Validate Database Recover ...
    (microsoft.public.fox.programmer.exchange)
  • RE: PLEASE HELP ME
    ... DanielWalters6 wrote: ... I am unsure on exactly how to edit my ... > If you could give me any advice on how to edit my bios, ...
    (microsoft.public.windowsxp.general)