| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> heh
<1> Anyone know of a free tool like Enterprise Manager for use with SQL Server Express 2005?
<2> toad
<3> its not free isit?:P
<2> what?
<2> i was just throwing random insults at him
<2> oh ok, theres a freeware version i think
<2> http://www.toadsoft.com/toadsqlserver/msql_lic_agree.html
<1> actually, i just found "Microsoft SQL Server Management Studio Express - Community Technology Preview (CTP) November 2005"
<4> lol Cheney shot someone in the face yesterday
<2> haha yea
<2> what a dolt
<4> at least Clinton made his 100+ murders look like suicides or missing persons
<2> well, im not really convinced clinton murdered anyone personally, but good call
<4> plausible deniability
<1> hey guys, im going to be trying SQL Server 2005 Express on a clients machine tomorrow and had no time to test
<1> can i run a .sql script on it somehow and create my DB?
<1> noremally i do that through the Query Analyzer
<1> but i guess sinces its Express, i cant do that
<4> you mean you need to do something without a GUI? NOOOOOOOOOOO
<4> actually they give you a few to download
<2> you just need a tool capable of running queries
<2> typically, msde came with osql.exe, im sure express has something similar
<1> well..if i install it on this machine that has SQL Server 2000 Enterprise, it wont mess with it will it?
<2> hm im not sure, i heard early versions of 2005 screwed with an existing 2000 install
<2> but im almost certain they fixed that now
<4> it wont even mess with an msde install
<4> but if you install MS anti-spyware itll see it as a virus and delete it ;) sort of like norton
<1> eek
<5> Jarett__ : yeah, 'cos bush senior and junior never killed anyone except a few tens of thousands of ragheads, and they don't matter to anyone...
<4> exactly
<4> and clinton only killed thousands of hatians, and tens of thousands of bosnians, and the list goes on
<5> actually, the bosnians were killed mostly by europeans and other bosnians
<5> but hey, you're and american, i don't expect you to know anything beyond your borders
<5> g'night all
<2> heh
<6> hey.. using MSSQL.. what is the most efficient way to get the last row id entered.. using "select max(id) from blabla"? or is there anything more efficient and faster?
<1> SELECT @@IDENTITY
<1> its in the books online
<6> i've looked but there's SO much.. hard to find the best way..
<1> just type @@IDENTITY in the index
<2> well, now you know
<1> this Micrososft SQL Server Management Studio btw is dog *** slow
<2> yeah, usually anything called studio is **** slow
<1> the Enterprise Manager for 2000 was nice
<1> just not a lot of features
<6> i must be missing something.. but typing "SELECT @@IDENTITY FROM posts" just gives me 3 null rows..
<2> you select @@IDENTITY after you have inserted the row
<2> and you must have an int identity column on that table
<2> as your id
<4> maybe your database is in Stealth mode, and it's identity is protected
<6> ahaaaaa.. you mean in the insert..
<2> after the insert
<1> after the insert
<7> after the pants?
<8> anal dwellers
<7> thats cute
<8> worked. yesss
<9> Would anyone know how to completely transfer a coppermine install to a new server. I've copied the entire do to other serv, re-edited config files, but Its a no-go still. Thanks.
<9> do=dir*
<10> 'coppermine'?
<9> yes. It is a mysql image gallery system
<9> would show url but dun wanna get banned ? heh
<10> that's ok, you don't need to show the url to get banned, it's still a mysql question...
<9> alliniquity.com
<9> Im trying to xfer it to alliniquity.net , which is hosted by 1and1, instead of x10
<9> lol
<9> at least it wasnt a ban
<9> :)
<10> did the rules and topic not give you a clue?
<9> apparently not. First time I read it just streamed as msql homework, figured ya just didnt wanna help people learn like that
<9> but aiight, thanks haha
<10> http://www.techeblog.com/index.php/tech-gadget/wr-07-a-real-transformer
<11> why would one not want to enforce referential integrity between a category and subcategory entity in an online auctioning database driven site?
<12> hello
<12> Hi im using MySQL database and trying to query it using this piece of code http://sql-servers.com/nopaste/?show=245 .
<12> But just seem to keep getting errors
<13> schone read the topic
<13> 1. it is using mysql 2. that isn't a sql question
<13> 3. "But just seem to keep getting errors" is not a real error
<14> Msg 50000, Level 16, State 1, Line 1 You seem to keep getting errors.
<13> haha
<13> sure it isnt a level 1 error?
<15> poor bastard
<15> the solution is mindnumbingly simple
<15> they shouldn't let idiots program
<13> hehe
<16> I have a table (in a mssql db) where `id` is set as primary key and auto_increment. For some weird reason the auto-increment counter has jumped to 8,388,607 when it should be 238,343. I tried this statement -> "ALTER TABLE table AUTO_INCREMENT = 238343" and it says "Query successfull" however the next value still reverts back to counting from 8,388,607 "( Please help!
<13> hehe
<16> I have a table where `id` is set as primary key and auto_increment. For some weird reason the auto-increment counter has jumped to 8,388,607 when it should be 238,343. I tried this statement -> "ALTER TABLE table AUTO_INCREMENT = 238343" and it says "Query successfull" however the next value still reverts back to counting from 8,388,607 "( Please help!
<17> why did you just repeat that
<16> sorry mate, i got disconnected, rejoined the channel just incase someone wrote a reply and i missed it.
<13> so if someone wrote a reply, you wanted to repeat your question again?
<16> no, i would have appreciated it if someone replied, they would re-post their solution.
<17> welp nobody replied :P
<13> i thought about it
<17> why is it a problem that the counter went to 8 million anyway?
<13> don't rely on auto incriment to be sequential g33kx0r
<13> if it is required to be sequential, make your own incriment
<16> tenfour: 8388607 is the largest value of a signed mediumint.
<16> Darken: thanks, didnt want to re-invent the wheel =)
<13> you're making a custom wheel with diamond studs
<13> :/
<16> anyway, any idea what could be going on?
<13> you inserted a lot of data and deleted it?
<16> nope, just moved from one server to another
<16> everythign else works fine except for this one table :'(
<16> all the other increments are working as before..
<13> renumber it then if you want, but still if you must have sequential then id suggest making your own if items are going to get deleted
<18> I'm looking for a WinXP database app to organize my files. Does anyone know of one that allows me to place my files into multiple categories (say project_foo, engineering, images) and then reference them by category? i've been managing my bookmarks this way for almost a year now and it has been much more useful than drilling through a hierarchy to find one.
<19> you're looking for a ready made thing? cause a db is only as simple or complex as the person that creates it
<19> filemaker pro may be your style
<18> well, looking for something that allows me to create the db for file management
<18> ready-made, yes thought.
<18> though even.
<19> so, you're looking for a 'file manager' ?
<19> i was trying one out a while back, let me think of the name
<19> less a db than a shell
<19> directory opus
<19> check that out, it may appeal to you
<18> yea organizer/manager.
<18> is filemaker pro used for anything like that?
<19> its a very easy 'database' creator
<19> database in the 'something used for managing data' sense
<18> can i link to files with it?
<19> i believe so, yes
<18> that may be what i'm looking for i'll look into it more. i end up with a mess from using single directory names... winFS sounds like what I'm ultimately after, but i'm sure that's years away still
<20> SELECT foo, MAX(bar) FROM table GROUP BY foo
<20> now this works, but I also want to fetch additonal coloumns from that same table
<20> but..
<20> SELECT foo, foo2, MAX(bar) FROM ...
<20> fails
<19> just add them all to the group by as well
<20> but that doesn't give the grouping I want
<19> then you need to alter your requirements or have more than one query
<19> which db
<20> postgresql
<19> can probably get away with:
<20> if I have to iterate through the results of the first, it's A, not going to be accurate, and B going to be a big performance hit
<19> SELECT t1.foo, t1.foo2, maxBar = (SELECT MAX(t2.bar) FROM table t2 WHERE t2.foo = t1.foo GROUP BY t2.foo) FROM table t1
<20> I'll give that a try, thanks
<19> well, you either must group by all the non aggregate columns or not have them in there
<20> yeah. I was experimenting with subqueries just now but it didn't quite work out. I've been working with just simple queries for too long :\
<19> i wouldn't totally go with my suggestion if you can change your approach
<19> it will execute one additional query per row
<19> which can be a lot if your resultset is large
<20> *nod
<20> but at least it will be pushed down to database level
<20> instead of doing post-processing in php
<19> sometimes its best
Return to
#sql
or
Go to some related
logs:
#solaris
#politics
mo6alaqa
#beginner
northbridge loops cooler fanless -nbf47
#firebird
#sex
#solaris
tcl stripcodes function
#beginner
|
|