| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> you couldn't afford me
<1> haha
<0> not that i would consider 'working' for you in the first place
<1> well whats the perice for the answer to my question
<0> knowledge?
<1> accept e-gold? =)
<0> 1000 dollars. i have paypal.
<1> this is driving me crazy
<0> crime doesn't pay dude
<1> you are right
<0> whats the most funny is that any hacker worth a **** couldn't be bothered to tell you what to do and any legitimate person wouldn't tell you out of principle
<0> your options appear limited
<1> right but u been very helpful in the past
<0> no doubt i didn't know what i was helping with
<1> mssql is not my field am just screwing with this trying all possible techniques
<0> thats what hacking is all about, is it not?
<1> its not hacking
<0> oh, sorry, thats what security analysis is all about
<1> penetration testing already played with sql 7 now am messing with 8
<0> penetration testing
<1> all i am doing is following a paper and trying to copy the darn thing
<1> i already did everything else possible, crackin the hashes etc
<0> email the author man
<0> tell him he ****s
<0> crackin' the hashes, eh
<1> i got him on msn =) but he is in argentina
<0> whats his name
<1> cesar
<0> i knew a cesar from argentina once
<1> right from appsec
<1> dfworking: so is there a default identity field in mssql to be used for row count?
<0> no
<1> hrm am reading that i might have to add a counting columnn without damaging dbase structure and do it like that?
<0> no
<0> everything you need you already have, you just don't know it
<1> hrm ok
<1> am gonna go read sql newbie tutorials see ya tomorrow
<0> i'll try to restrain myself
<2> Hi, I'm using DB2 and was wondering if anyone knew the command to see the details of a table (i.e. the attributes). I've tried searching the internet but can't find the correct term and I've tried reading any info I have.
<0> DESCRIBE i think
<0> sec
<0> http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/r0002019.htm
<2> thanks, let me take a lookie.
<0> describe table user.table
<2> yeap, just saw it. thanks a lot!
<1> dfworking: tahnks for the help[ seems there was a clolumn that was being used as the counting key
<3> How do I do something like this in MSSQL. INSERT INTO table (c1, c2, c3) VALUES ((SELECT v1 FROM t2)), 'v2', 'v3'); I have understood that you can't use VALUES when using subqueries in INSERT in mssql. How should this query look?
<4> hi all
<4> I am trying to get 3 random results from a sql query how can i do it?
<5> bit difficult
<6> Hello, is it possible to get a list of dates from-to from sql without a table of dates?
<0> which db
<6> borland interbase
<0> don't know, but using a lookup table of dates will be the most portable/usable
<0> you sure you need one?
<6> it is for a stored procedure.. with several selects.. which get data from provided dates
<0> doesn't tell me much
<6> i could just make a table and insert the dates i want to get data from before i call the stored proc. of course.. maybe i'll just do that :)
<6> it just seemed weird
<0> not really, but if interbase allows it, just leave the table
<0> populate the table up to 2010 or something
<7> morning
<8> hey if i have a sort of a tree in a table ie. (ID,Name,ChildOf) when ChildOf is holds the parent row the roots ChildOf's field=0 and thier direct childs have 1 ect... how can i delete from the root and al the childs at once ?
<7> children u mean :)
<7> HMS: if you have foreign key restriction with cascade on delete it will automatically do it
<7> you have also not specified your rdbms
<9> HMS: delete from table where ID in (select ID from table .. connect by ...) if its oracle
<7> ztod_: given that he didnt wnat to tell us what db he is using...
<9> oh
<7> ztod_: connect by does recursive?
<9> SicLuDe: yes
<9> well not necessarily, but the result equals to a recursive walk
<7> ok
<7> good to know
<0> ARE YOU NOT ENTERTAINED? ARE YOU NOT ENTERTAINED?
<7> i am now
<0> ARE YOU NOT ENTERTAINED? ARE YOU NOT ENTERTAINED?
<7> dfworking: what the hell did u smoke?
<0> ****ing thank you GatsaGama
<10> np
<10> in payment you can help me with this MySQL -> MSSQL thing you advised me on the other day :D
<7> *gasp* he said MySQL
<0> err, um, don't recall
<10> was in #cf
<0> heh, i still don't recall the specifics
<10> I don't want to buy software to move this giant MySQL database to MSSQL, nor do I want to do it table by table because it's m***ive.
<10> And my MySQL ODBC driver that I installed (which you suggested so I can just do DSN -> MSSQL) stalls when I enter the server information.
<0> which version of myodbc
<11> waaaaaah
<10> 3.51 Driver.
<0> well, i know there are a few toggles in that interface that should be turned off, but its been a looong time since i've messed with it
<7> eh export everything to cvs and import using DTS
<10> I exported to cvs and DTS thought it was all one gigantic table.
<10> then threw errors on the import.
<7> so correct the errors :)
<10> I refuse to do any grunt work on this due to the fact that I'm morally opposed to MS SQL 2000 being unable to import a .sql file via DTS.
<0> you execute sql files
<0> and dts is hands down the best free migration tool evah
<10> It's free?
<0> sure, it comes free as a bonus when you buy sqlserver
<12> Hi
<10> heyy, wait a second here, can I just cut and paste the entire .sql into the uhh
<8> ooppss
<10> I've forgotten the name it's been so long since I used it.
<7> QA
<0> query analyzer
<8> forgot my to check out the answer to my question :x
<10> that's the one.
<8> im using mssql
<7> which version?
<8> i mean access
<8> bla im tierd =\
<7> best would be to just add foreign key constraints and do cascade on delete and then delete the root.. that should delete them all
<12> When using MS SQL + ADO.NET to update records in a table with identity column, is it better to use an SP with OUT parameter to retrieve the new identity value, or to use batch command processing, ie an extra SELECT command after the insert ?
<8> but its on the same table
<7> so?
<8> can i add a foregin key on the same col ?
<7> i should be able to add a foreing key constraint that points to the same table
<7> just made sure that ur root nodes are NULL
<8> ah
<7> its not the same column
<8> amm they are 0
<8> not null
<7> the Child column points to the ID column
<8> ya
<7> two diff columns
<8> i c
<7> well u dont wnat a child column... it should be more an ID and a Parent column
<7> and the parent for the root rows should be NULL
<7> otherwise you will get a circular referencing
<13> hi , using msde. http://sql-servers.com/nopaste/?show=494. At the Top is the desciption of both tables.
<13> And beneath that is the sproc.
<13> I want to group by member in a way, where member could be user1_id or user2_id.
<0> eh?
<13> i know its not making sense to me either, i just want it done that way
<14> if you use an alias for a calc field in oracle can that alias be used in a having/where clause?
<7> Whooo: dont think so
<14> me either...unless you nest your select within antoher select
<14> aight..thanks
<7> quiet today
<13> k suppose i have 4 columns, [player1], [player2], [player1frame], [player2frame]. I want to group by all the players. If they were player1 or player2
<13> can this be done
<15> how do I limit the record sets results ?
<13> i mean if a player was ever player1 or player2
<13> for all players
<7> they should all be 1 column
<13> right, but if a billiard match consists of 2 players. I mean i still dont get it.
Return to
#sql
or
Go to some related
logs:
#unixhelp
zephrenin
nick generator freenode
#linux-noob
erection reset by beer
#stocks
unload anywhere + 5
#politics
#flash
#linux-noob
|
|