O koks ilgas atsakymo variantas? 
-- 

=^_^=
.

"Gintautas" <gintuoklis{@}gmail.com> wrote in message news:hf7qht$vng$1@trimpas.omnitel.net...
> jei trumpai, tai sugrius logika
> "Audrys" <oginiekienoreikalaskokiadeze@takas.lt> wrote in message 
> news:hf7qd9$vea$1@trimpas.omnitel.net...
>>o kodel?
>>
>> "Gintautas" <gintuoklis{@}gmail.com> wrote in message 
>> news:hf7oln$s98$1@trimpas.omnitel.net...
>>> nea
>>> "Audrys" <oginiekienoreikalaskokiadeze@takas.lt> wrote in message 
>>> news:hf7jhs$l5c$1@trimpas.omnitel.net...
>>>>o gal pasilikti tik viena lenta, o kitos vardu padaryti view'a?
>>>>
>>>> "Gintautas" <gintuoklis@gmail.com> wrote in message 
>>>> news:cnldh5dj3t9cf3egraan6sf47j6gffa1o0@4ax.com...
>>>>> Sveiki,
>>>>> Nesu SQL programuotojas, tai prasau jusu patarimo kaip reiktu padaryti
>>>>> toki dalyka.
>>>>>
>>>>> Yra dvi lenteles table1 ir table2(toj pacioj bazeje). Ju schemos
>>>>> identiskos. Ka as noriu padaryti. tai jas sinchronizuoti. Glavoju
>>>>> sukurti table1 trigerius OnInsert, OnUpdate, OnDelete.
>>>>>
>>>>> Pirmiausia pameginau padaryti OnInsert. Rasau taip:
>>>>> INSERT INTO table2
>>>>> SELECT table1.*
>>>>> FROM table1
>>>>> WHERE [no] = (select [no] from inserted)
>>>>>
>>>>> Tada man sql pradejo keiktis del timestamp lauko esancio lentelese.
>>>>> Kaip suprantu as negaliu parasyti taip:
>>>>> SELECT table.* except [timestamplaukas]
>>>>>
>>>>> As galeciau isvardinti visus laukus, bet nenoriu vardinti visu lauku,
>>>>> nes pasikeitus lentai nesinori modifikuoti trigeriu.
>>>>> Turbut galiu paselectinti lauku sarasa is kokios sistemines lentos?
>>>>>
>>>>> Na kaip jau minejau nesu SQL programuotojas, tai gal apskritai viska
>>>>> not in SQL way. Zodziu uzveskit ant kelio kaip viska teisingai
>>>>> pasidaryti. Beje yokiu lenteliu "poru" bus ne viena.
>>>>
>>>>
>>>
>>>
>>>
>>> __________ Information from ESET NOD32 Antivirus, version of virus 
>>> signature database 4656 (20091202) __________
>>>
>>> The message was checked by ESET NOD32 Antivirus.
>>>
>>> http://www.eset.com
>>>
>>>
>>>
>>>
>>
>> 
> 
> 
> 
> __________ Information from ESET NOD32 Antivirus, version of virus signature database 4656 (20091202) __________
> 
> The message was checked by ESET NOD32 Antivirus.
> 
> http://www.eset.com
> 
> 
> 
>