Re: Syntax to add records if primary key = list
- From: "Alwik" <alwik@xxxxx>
- Date: Wed, 21 Sep 2005 23:16:15 +0200
> I am new to SQL administration.
>
> >From a list of IDs that are the primary key in one table (i.e. Customer
> Table), I want to make changes in tables that use those IDs as a
> foreign key.
>
> Basically I want to say:
>
> If fk_ID is in list [1,2,3,4,5] then
> do these statements to that record
> End if
>
> Where do I begin?
>
> Thanks for help with this low-level view of SQL programming.
>
Let's try a simple example
Customers table has a field cust_id, orders table has field ord_freight and
ord_custId which is FK.
When you want to update ord_freight for known customer ids you can execute:
UPDATE orders SET ord_freight = 15 WHERE ord_custId IN (1,2,3,4,5)
but let's assume that you know only names of cusomers - then you can use
joins and filter orders using using names and relations between tables.
I think that the best place to start reading are MS SQL Server books
online - look for topic: update (described) - there are some examples etc.
You can use cursors as well and process records on a one by one basis, but I
think that update will solve many of your problems.
I hope this helps
Tomik
.
- Follow-Ups:
- References:
- Prev by Date: Re: Dynamic data elements for a data collection application
- Next by Date: Re: searching a list of tables, derived from another table
- Previous by thread: Syntax to add records if primary key = list
- Next by thread: Re: Syntax to add records if primary key = list
- Index(es):
Relevant Pages
|
