SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 08:11 AM
| ||||
| ||||
 -565 (-111) begin work; create temp table ttt ( a char, b char ) with no log; insert into ttt ( a ) values ( 'a' ); insert into ttt ( a ) values ( 'b' ); create procedure ttt( ) define v char; foreach select distinct a into v from ttt on exception in ( -206 ) end exception with resume; if v = 'a' then create temp table aaa_bbb ( f int ) with no log; end if; update ttt set b = v where a = v; drop table aaa_bbb; end foreach; end procedure; execute procedure ttt( ); Oops! Any comments? -- Бесплатный почтовый ящик предоставлен http://pasts.delfi.lv sending to informix-list      |
Linear Mode
