PCFormat Forum Archive

How does one enclose semi colons on the SQL coding like this. set option escape_character='on' go load table blablaba( [Car_id] '|', [Money] '|', [IDTitle_IA] '\x0d\x0a') from '/shared/data.txt' escapes off quotes off on file error rollback skip 1 go set option escape_character='off' go (just to let...

Hi,

How does one delete a file off aqua studio (which uses SQL language).

I wanna DROP the file (similar when you drop a table as in DROP TABLE blablabla...)

Thanks

example please!!!??? Using my wacky sql...hahaha.. thankz!!!

Ok maybe you not getting my question. I have 5 UPDATE statements. Both these UPDATE statements read from 2 tables, and I am joint condition with their unique/primary key (i.e. where a.id1 = b.id_no) Both these UPDATES share at 1 least criteria (i.e. where field_name1 is in ('X',Y',Z'). However there...

Hello, I need some advice. I would like to have one SELECT statement which allow do multiple updates for me. At the moment, I have 5 seperate updates. So id like to get it into one select statement. For legal reasons, I wont use the actual select statement, but I will put a rough example of what I m...