Search found 5 matches
- 08 Jan 2010, 11:16
- Forum: Databases
- Topic: the semi colon...("the one way run")
- Replies: 0
- Views: 5200
the semi colon...("the one way run")
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...
- 08 Jan 2010, 11:12
- Forum: Databases
- Topic: delete a file using Aqua Studio
- Replies: 0
- Views: 5009
delete a file using Aqua Studio
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
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
- 07 Jan 2010, 16:42
- Forum: Databases
- Topic: Having ONE select statement for Multiple Updates
- Replies: 5
- Views: 5468
Re: Having ONE select statement for Multiple Updates
example please!!!??? Using my wacky sql...hahaha.. thankz!!!
- 07 Jan 2010, 15:47
- Forum: Databases
- Topic: Having ONE select statement for Multiple Updates
- Replies: 5
- Views: 5468
Re: Having ONE select statement for Multiple Updates
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...
- 07 Jan 2010, 10:56
- Forum: Databases
- Topic: Having ONE select statement for Multiple Updates
- Replies: 5
- Views: 5468
Having ONE select statement for Multiple Updates
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...