[SQL] Update Problem

2006-06-05 Thread Christian Paul Cosinas
Hi,   I’m encountering some weird problem on Update.   I have a program that updates a table and it updates more than 1 column at a single query. Like this one:   Update table1 set column1 = ‘a’, column2 = ‘b’, column3 = time ’08:00 AM’ where column1 = ‘c’   Sometimes only column1

[SQL] ORDER BY question

2006-05-10 Thread Christian Paul Cosinas
Hi, For example I have a table like this ID Name 1 A 1 B 2 C 2 D And I have a Query like this: SELECT * FROM table ORDER BY ID. Would my result always give me the same order or is there may be a possible different result? For example? 1 B 1 A 2 D