| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> Maybe through the SQL management API
<1> i'll look into it
<2> i've created a new line by insert and added 2 values, now i need to update another 2 values from the same table selected by name, i've done: UPDATE youngster SET y_birthdate = (select y_birthdate from youngster where y_name='a') WHERE y_name='b'; and i get 'have to use updateable query', why is that?
<2> is there any way to update a table using select from the same table?
<3> is there a method of exporting a query to a file in postgres?
<3> i know there "copy", but that just dumps the table
<4> elad__: Help could, possibly, be more forthcoming if you read the rules messaged on join, and provide enough information.
<5> MSSQL 2000: Is there a built-in SQL function which returns the data type for a specific column in a table? "COLUMNPROPERTY" doesn't give me the general data type I'm looking for.
<6> any closet oracle gawds around here?
<6> I'm trying to extract all the SQL of all the views in a 10g database
<6> ...and, of course everyone is already on vacation
<7> set long 10000
<7> select view_name, text from user_views;
<2> if i have a table with a list of days and activitys, and i need to return by sql statement the activitys that appear in every day, how can i do it?
<8> depends on how the days and activities are related/stored
<6> ahhhh. thanks, the set long thing is probably what I was missing, I thought the stuff wasn't there
<2> upb: hm... in no way, you have a list of days (numbers : 1 ... 10 lets say) and activitys is just text, and you need to check if there are activitys which appear every day (from 1..10)
<6> awsome, I owe you a beer
<8> elad__: then its impossible :)
<8> if you have two tables
<2> upb: can't you use exist or something like that?
Return to
#sql
or
Go to some related
logs:
#politics
rscmpt.exe
localhost kernel: CPU0: Temperature above threshold
#politics
#wtf
#nhl
+usb +2 +only +runs +1.1
#delphi
#beginner
#beginner
|
|