| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> how to specify a null string in SQL?
<0> is "" valid? or ''? or what?
<0> null i mean empty, not "NULL"
<1> hey guys, was wondering if anyone had this book as an ebook ? Database System Concepts, Silberschatz, Korth, Sudarshan. need it for uni but too povo to buy it, thanks :)
<2> why don't you try p2p
<2> you'll have more success than asking on irc
<1> i'm trying limewire at the moment, doesnt seem to be there
<2> i see it on edonkey
<1> hmm, might have to download edonkey then
<2> which os
<1> xp
<1> how big is the file ? the ebook i mean on edonkey
<2> **** dude, just get shareaza
<2> does all of them
<1> alrighty
<2> anywhere between 519kb and 191mb, heh
<2> all pdf
<2> don't think i've ever seen a 191mb pdf though
<1> yeah i reckon lol
<2> thing better take the ****ing tests for you too at 190mb
<3> I'm getting this error with SQL server 2000,hope someone can shed some light on what i am doing wrong or missing
<3> http://sql-servers.com/nopaste/?show=339
<4> Yeah, that ain't legal
<3> talkin to me HF?
<4> yes
<5> I dont think MSSQL allows doing selects off of subqueries
<3> ahh k, what can i use instead, i tried an if statement originally
<6> need a select before the case
<3> umm u can whiz
<3> i did select from subs before
<6> oh wait, lol thats funny
<5> how? select * from (select * from something) didnt work for me
<3> no
<3> select date from something where in (select date from tblname)
<4> Disabuse: You can't conditionally change the source of the subquery, period.
<4> SELECT * FROM (SELECT * FROM x) AS y
<4> That's perfectly legal MSSQL
<5> unless you use T-SQL
<6> select date, moms, dads from (select case blah when 1 then select yourmom from bed end) as tblname might work
<5> good to know Halo
<7> if you need an opera screenshot let me know. ill make one
<3> any suggestions on how i can get the results i want based on this type of scenario?
<3> because i am using what ever select stmt for t3 different union joins
<3> t3-->three
<4> You can do that sort of condition outside of the query.
<8> You can select from subqueries, you just have to give the subqery and alias.
<8> Oh, wait. I see.
<8> Yeah, that don't work.
<9> I'm using DB2 and was wondering what happens if I create an index on the table, drop the table, then recreate the table? Will the database re***ociate the old index with the new table and mantain it, will it generate errors, or will it just ignore the index?
<10> nope
<10> it should drpo the index with the table
<9> cool
<9> Any idea how I can create multiple indexes in a single statement? Separating them with a semicolon gives me an error that the semicolon is unexpected.
<11> why do you need to do in a single statement?
<10> youd need to run it as a script
<9> I don't necessarily need one statement, it would just be cleaner
<10> if its a series of statements
<10> yeah you can't do one statement for multiple indices
<11> well then you cant
<9> okay... now I gotta figure out how to run a script on an AS/400 =P
<9> I guess I could create multiple stored procedures
<9> or could I create a stored proc that takes the CREATE INDEX statement as a string, PREPAREs that, then EXECUTEs it?
<8> There has to be a way to run scripts.
<8> I'd try to figure that out instead of hacking aruond it.
<9> How is this script you're talking about structured?
<8> I could tell you how it is done in Oracle or SQL Server, but not in db2. :)
<9> okay, I can probably translate it
<8> Probably not. Its a question of figuring out how to seperate statements and what util to use.
<8> Oracle, use sql plus, put a / between statements. SQL server, use Query Analyzer, put a GO between statements.
<9> oh, so it's just separating the multiple statements in a way that the application processing them understands to separate them
<8> And using the query tool that comes with your db to connect to it. I ***ume db2 has something similar to QA / SQLPlus.
<9> I'm running this in an app on the AS/400 directly, it has all that built into the server.
<4> Isn't GO the ANSI terminator?
<12> well you can change the "GO" separator in SQL server 2000 to something else
<12> to something like "wtf"
<12> well i think i might give it a try ~ ? :)
<9> apparently I have to create a file with the statements, then use RUNSQLSTM to execute them
<9> I'll try GO
<8> Halo: Don't think so. The db doesn't understand "go", qa and em strip it out and send the statements alone.
<9> Keyword GO not expected. Valid tokens: <END-OF-STATEMENT>.
<13> only query analyzer/osql undertands GO, the db engine itself doesn'
<13> t
<8> Oh. Looks like DB2 doesn't expect a terminator between statements.
<8> http://www.cas.mcmaster.ca/~cs4eb3/db2/using_db2.html
<9> *shrug* I haven't a clue what the hell all these parts of working with DB2 on an AS/400 are.
<12> Drk`Angel:: have you tried ";"? i am not sure about other RDMS...
<8> Search for the 3rd occurance of the words "db2 script"
<8> And start reading.
<9> yeah, I'm reading
<9> looks like each CREATE INDEX is going to be in a separate file and get called sequentially
<8> No, I think you just want -n -t :)
<8> -n -t -f
<8> Actually.
<9> I'm not using anything like that db2 command
<9> I'm using RUNSQLSTM
<4> Drk: I know, but I thought that was an agreed upon delimiter.
<4> I know ; is ANSI
<9> RUNSQLSTM requires I p*** in a library and a member, which is roughly equivalent of a folder and a filename
<8> http://www.rpgiv.com/kb/RUNSQLSTMT.html
<8> Looks like ; should work.
<9> let me try it that way
<9> creating the file is a pain and I haven't done it yet :-\
<9> well it apparently doesn't delete the index when the table gets deleted
<8> db2 is weird.
<9> especially on an AS/400
<9> and actually the app that is supposed to rebuild these tables didn't run this morning like it was supposed to, and the ERP admin didn't tell me
<7> wtf
<8> That would be an email harvester.
<8> Its one of the reason why my client jsut ignores most ctcps nowadays. :)
<14> i have a table with some fields and a AddDate, how can i select all the fields but the last(est) rows that the AddDate is the biggest(l***edt added to the db) ?
<14> last*
<11> max
<11> max(adddate) group by all those other fields
<14> not in the where ?
<14> max in the select ?
<11> max in the select
<11> group by after the where
<14> ie : select max(adddate) group by f1,f2,f3,...(* ?) where categoryid=1
<14> that hould work ?
<11> you cant use *
<11> but thats the idea
<14> SELECT MAX(AddDate) FROM Voting_Questions INNER JOIN Voting_Answers ON Voting_Questions.ID = Voting_Answers.QID Group By Voting_Questions.Question, Voting_Answers.Answer Having Voting_Questions.ID=1 And Voting_Questions.CategoryID=1;
<14> whats the problem here ?
<14> =\
<11> whats the error?
<11> and why are you using having?
<14> when i used Where i got the error missing oporator
<14> operator*
<14> what u think ?
<11> I think you dont make sense
<15> HMS, let me attempt a translation: do you want the rows from the table, for which, for the given set of columns, the adddate is the "biggest"? In other words, if three rows have the same set of columns, you want the row that features the most recent adddate?
<15> I think he's Asian
<16> $5 ok? you $5 ok?
<14> lol
<14> no
<14> im not
<14> amm but i think ill do it in 2 querys
<14> thx anyway :)
<16> so funny gamble
<15> not meaning anything by that; I work with a lot of Asian people, and he had that particular english syntax going on
<16> the one that goes: $5 ok? ok?
<15> no.
<16> :/
<14> lol
<15> HMS, i took time out to ask you for a clarification and you did not respond. Perhaps if you did, I could offer you a query.
<15> <-----[12:31] <15> HMS, let me attempt a translation: do you want the rows from the table, for which, for the given set of columns, the adddate is the "biggest"? In other words, if three rows have the same set of columns, you want the row that features the most recent adddate?
<16> goodluck
<16> i appreciate you trying to help at least gamble
<14> amm
<15> thanks :)
Return to
#sql
or
Go to some related
logs:
#politics
logwatch crypted
compare+constrat
austnet spam
#firebird
#politics
#linuxhelp
#unix
#delphi
#computers
|
|