Re: help in database updations.
From: Andrew John (aj_at_DELETEmistrose.com)
Date: 05/07/04
- Next message: Jacco Schalkwijk: "Re: Can I install SQL Server Enterprise on Windows 2000 SBS"
- Previous message: Tibor Karaszi: "Re: xp_cmdshell problem"
- In reply to: SPG: "help in database updations."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 7 May 2004 17:44:08 +1000
SPG,
Agree - post your code if you want help with it.
Some comments in line:
"SPG" <not@noreply.com> wrote in message news:e8QgnC$MEHA.1392@TK2MSFTNGP09.phx.gbl...
> Hi all,
>
> Let me first explain what I am trying to do. I have a web app, where from my
> asp page, i call a stored procedure.
>
> Now this page is used by N users concurrently. This SP updates a table,
> updates a second table with first as ref,
>
> and clear first table. in between there is a delay of few seconds, which i
> have explicitly put( waitfor delay command)
Are ye mad ! A waitfor delay command has no place there. The cure is FAR worse
than the disease.
>
>
> but teh problem appears when some users at the same time use this page, and
> update table, then the records by only one user are present in the table,
> the same for all teh other users are found missing later.
>
Need to read up on concurrency and record locking.
> why are the updations made by the other users not updated in the second
> table?
>
> what am I missing here?
>
> TIA.
>
>
- Next message: Jacco Schalkwijk: "Re: Can I install SQL Server Enterprise on Windows 2000 SBS"
- Previous message: Tibor Karaszi: "Re: xp_cmdshell problem"
- In reply to: SPG: "help in database updations."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
