default tables

hi all
is there any one who can tell the basic idea behind inserted, deleted mssql table. how these r affected on dml operations.
i m new to mssql.
thanksInserted and deleted are two special tables used in the trigger statements.

The deleted table stores copies of the affected rows during DELETE and UPDATE statements. During the execution of a DELETE or UPDATE statement, rows are deleted from the trigger table and transferred to the deleted table. The deleted table and the trigger table ordinarily have no rows in common.

The inserted table stores copies of the affected rows during INSERT and UPDATE statements. During an insert or update transaction, new rows are added simultaneously to both the inserted table and the trigger table. The rows in the inserted table are copies of the new rows in the trigger table.

Check BOL for more information.

Harshal.

Default priority

What is the default priority of the SQL Server 2000 operations ?
7 or 13 ?SQL Server process runs at normal priority level, by default. I am not sure
about the priority number, in terms of C programming.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:OW2bgHN2DHA.3496@.TK2MSFTNGP11.phx.gbl...
What is the default priority of the SQL Server 2000 operations ?
7 or 13 ?|||So what is the normal priority level by default ?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:#n$btlP2DHA.3656@.TK2MSFTNGP11.phx.gbl...
> SQL Server process runs at normal priority level, by default. I am not
sure
> about the priority number, in terms of C programming.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:OW2bgHN2DHA.3496@.TK2MSFTNGP11.phx.gbl...
> What is the default priority of the SQL Server 2000 operations ?
> 7 or 13 ?
>
>

Default priority

What is the default priority of the SQL Server 2000 operations ?
7 or 13 ?SQL Server process runs at normal priority level, by default. I am not sure
about the priority number, in terms of C programming.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
news:OW2bgHN2DHA.3496@.TK2MSFTNGP11.phx.gbl...
What is the default priority of the SQL Server 2000 operations ?
7 or 13 ?|||So what is the normal priority level by default ?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:#n$btlP2DHA.3656@.TK2MSFTNGP11.phx.gbl...

quote:

---

> SQL Server process runs at normal priority level, by default. I am not

---

sure

quote:

---

> about the priority number, in terms of C programming.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
> "Alan" <NOSPAMalan_pltse@.yahoo.com.au> wrote in message
> news:OW2bgHN2DHA.3496@.TK2MSFTNGP11.phx.gbl...
> What is the default priority of the SQL Server 2000 operations ?
> 7 or 13 ?
>
>

---