| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> er, s/and/where
<1> select * from b where id not in (select id from ab)
<0> in my mind, on is always a synonym for where... (and they are, except in outer joins)
<1> that will also work
<2> I see...
<2> thank you guys
<0> halo_four and can also be more expensive
<1> I would expect the outer join method to be more expensive, the NOT IN isn't actually scanning any of the data of ab
<0> *shrug*, I run both through the query planner to figure out what's faster...
<1> I'd check it out but I don't feel like writing a script to create and populate a bunch of tables.
<0> indeed, as would I
<1> Although, I guess I probably have similar scenarios in test DBs
<1> yes, the left anti semi join is a tad faster.
<1> than the left outer join
<1> er, right anti semi join
<1> The join does most of it's work in a hash match, while the NOT IN does most of it's work in a stream aggregate. NOT IN is slightly less costly, but the difference is negligable.
<3> anyone know of a good open source parser and stemmer
<4> how do I change sa p***word?
<5> whats wrong with this code? http://sql-servers.com/nopaste/?show=192
<6> delete from car;
<6> where serial='&p_serial';
<6> maybe you don't mean to have a ; after the first line there?
<6> also put a ; after your update command
<6> i'm not sure if your rdbms requires you to do so
<6> but it's not a bad idea either way
<5> thanks for the suggestions i will try it
<5> error: unknown command "from car" - rest of line ignored" ... unknwon command begining "where seri..." - rest of line ignored .... whats wrong with this code? http://sql-servers.com/nopaste/?show=193
<7> delete *
<7> from car
<5> hmm still got the same errors
<5> weird
<8> anyone here?
<3> no
<8> (http://sql-servers.com/nopaste/?show=194) I ahve a problem where this query prints out every instructor too many times.
<8> I want it to print every instructor that is mentoring only freshmen...
<3> do
<9> you aren't doing any joins
<3> what's your common field in Person and Instructor
<8> there is an ID
<3> ok do where p.id = i.id
<3> or whatever :-)
<8> ok. I'll try that thx
<3> you know it is difficult to find a good PHP based parser and stemmer scripts
<3> that is open source
<4> morning YuppieScm
<5> whats wrong with this code? error above the code -> http://sql-servers.com/nopaste/?show=203
<5> unknown command "from car" - rest of line ignored. strange
<4> I don't know, can you have spaces like that?
<5> that doesn't matter
<4> I'm not familiar with "accept"
<4> is that mssql?
<5> thatsprompt - display a message on the screen
<5> accept - get input for a substitution variable
<10> what is the paste url?
<10> i have a question
<10> anyone here?
<11> its in the topic dude
<10> http://www.sql-servers.com/nopaste/?show=204
<10> pls. see this problem
<11> which db
<10> sql server
<10> ms
<11> whats this give you: http://www.sql-servers.com/nopaste/?show=205
<10> it list alls tuples
<10> i still need to group by ownername, while summing each salestype
<11> oh, so you just want the total price for each owner per salestype?
<11> sec
<10> yes
<11> try this: http://www.sql-servers.com/nopaste/?show=206
<10> thats it thanks
<8> I need help with a query. I'm getting a strange error. http://sql-servers.com/nopaste/?show=207. Thanks
<11> and
<8> dfworking: was that for me?
<12> ok
<12> I'm going to ask a question that probably has a basic answer
<12> but please humour me:)
<12> I need to execute a DDL and a SQL script in MS SQL2k5 Developer Edition
<12> but like
<12> where's query analyser gone?!??!?
<12> I can open the script in Management Studio
<12> but there ain't no run buttons;)
<12> any suggestions?
<12> anyone worked with 2k5 yet?
<12> ah
<12> oddness
<12> if it's .ddl
<12> it won't allow execution
<12> treats it as a .txt
<12> but if you rename it to .sql
<12> it's fine
<12> gives you the execute button etc. etc.
<12> thanks for the help:-P
<13> Is there a difference between using ; and go as separator on mssql?
<14> whats mssql?
<13> microsoft sql server
<15> Any of you have any experience with inserting images into an MSSQL Database and redisplaying them out?
<5> hey guys, what is the domain for 218.189.191.251?
<16> Hanif: ask your dns resolver
<5> unresolved but when i visit http://218.189.191.251/~richard it redirects to http://bespark.com/~richard/
<5> so is bespark.com the domain?
<16> again, ask your dns resolver
<16> what does bespark.com resolve to?
<17> When i do a backup of my database it doesnt include the stored procedures, i use SQL Server 2000
<17> Is it possible to backup everything?
<5> 218.189.191.251, when u type this in the address bar of Internet Explorer, it automatically resolves to beautyspark.com. Is this the domain?
<16> Hanif: you seem to mistakenly think that only one domain can point to an ip address
<15> ROFL
<15> I love that the corporate model blows lol
<5> grimmy-
<5> so is that considered teh domain then?
<18> I can't get an inner join to work correctly; is my syntax off? (http://sql-servers.com/nopaste/?show=210)
<18> I am inner joining twice; if I take either one of the joins out, it works fine.
<18> This is being used in an Access DB.
<17> So, does anybody know how to backup a database including all stored procedures, tables, views etc in MS SQL Server 2000?
<18> frW: Through SQL code?
<17> Aragorn16: SQL Server Enterprise Manager will work fine :)
<18> Gimme a sec...
<17> thank youy
<17> Aragorn16: i solved it! :)
<18> OK, good! Sorry I couldn't help...
<18> Break-fixes coming in from all over at the office. :(
<19> Is there any way to use DISTINCT or something similar in WHERE clause?
<19> Because I want to only select records where a particular field is unique, but I want to display all fields, not just the distinct one.
<20> select * from blah where foo in (select disticnt foo from blah)
<19> where both blah's are the same table and foo is the distinct field im interested in?
<13> Anyone know how to set the transaction timeout in oracle AS?
<19> JohnD: http://www.dbasupport.com/oracle/ora9i/ResumeOperation.shtml
<19> Drk`Angel: that doesnt work
<19> it doesnt make any difference to the query, just takes longer to execute
<20> duh, you're right. where foo in (select foo from blah group by foo having count(*)=1)
<21> hi all
<21> what is the best way to reset the count for an identity? just turn it off/back on?
<21> i'm looking for the syntax to turn off / back on identity on an existing table, i'm guessing some form of alter table, anyone around that knows offhand?
<21> mssql...looking at msdn now
<22> how to master sql, get $500k/yr salary
<22> plz some1 help
<20> Darken_: 1. Steal Underpants, 2. ???, 3. Profit
<23> is it possible to use an INNER JOIN with a self join on one table?
<24> yep
<19> OK I've stolen some under pants, what now?
<22> nice
<22> I'm rich
<25> how can i prevent 'Using filesort' on this query: http://pastebin.com/543286
<24> on a side note..
<25> my mistake
<25> and this query is bugging me :)
<18> I'm trying to execute this query ( http://sql-servers.com/nopaste/?show=212 ) in VBA via an Access connection. While it doesn't work in VBA, it does work as an Access query. It does work when I take the SIZES table/fields out of the query. What's going on?
<26> your using access specific stuff, but using an odbc connection?
Return to
#sql
or
Go to some related
logs:
#windows
w00tw00t +logs
#politics
ntuser.exe
#visualbasic
#nhl
#beginner
#delphi
cadillac.hu
pltn pacbell.net
|
|