| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> in SQL Server can you constrain a WHERE clause based upon another SELECT statement?
<1> yes
<1> select * from x where id in (select y from z)
<0> ah, wrong syntax right idea. :)
<0> thanks.
<0> for some reason query analyser is complaining about two updates within a BEGIN / END block. Any thoughts?
<1> http://sql-servers.com/nopaste/ it
<0> http://sql-servers.com/nopaste/?show=493
<2> How is it possible to do a mssql database transfer mssql to mssql using openrowset through http post request, without timing out the webserver and process?
<1> strategy- sorry i don't know :/
<0> tenfour: no worries. thanks.
<0> I had misspelled UPDATE
<3> heh
<4> Borgon : you were asking ealier for help on your "sql injection attack" methodology, and you got a KB for it
<4> Borgon : what makes you think this won't happen again?
<2> no no
<2> this is differenty
<4> reallyy?
<2> i finally got the poc working but now its timing out
<4> for surey?
<1> it's different-y... not exactly different, but close
<2> before i was asking if i had to create the fields
<2> or they werre gionna be auto created with syscolumns etc
<2> now am just asking hopw can i stop it from tyiming out
<5> bye
<6> [12:58] <2> How is it possible to do a mssql database transfer using openrowset through http post request, without timing out the webserver and process
<6> hahahaha
<4> indeed
<6> A) why would an admin need to bother doing anything like that
<0> testing?
<6> "yes. I'd like to trasnfer the red sea to the mediterranian using only a firehose"
<6> ..but I HAVE to use THIS firehose
<4> ...and the guys that own the red sea mustn't know i'm doing it
<0> did you ever think he might be testing his environment to harden it?
<4> no
<4> because if he was, he'd be using stored procs
<6> don't get me started on SQL injection 'attacks'
<6> reminds me a little to much of the Y2K 'bug'
<0> <2> hrm so its a server side asp setting,anyway to change client side? the tables are transfering but it times out and just stops =(
<4> strategy- : ask him which site it is, so you can check it yourself...
<4> then report him to the site operators
<7> how do i test if this constraint is true
<7> we cannot express the constraint that the specialization
<7> of workers to receptionists, nurses, and doctors is disjoint.
<7> we cannot express the constraint that the specialization
<7> of workers to receptionists, nurses, and doctors is disjoint.
<7> oops sorry for double paste
<8> TERM1NATE: shouldn't your prof have talked about that in cl***?
<5> term1nate : the rules say no homework
<7> oh, so you can't help me?
<7> would it be a crime
<5> TERM1NATE : so, this *is* homework?
<9> can someone tell me if this is syntactically correct? ... INSERT INTO LSS~OurHouse (ID) VALUES (8)
<0> I don't believe ~ is valid
<9> okay can i escape that character then?
<0> you can't have a table named that in the first place.
<9> thats the char i was worried about but i didnt design the database format and dont have access to alter it either
<0> what makes you think it's invalid?
<4> phr33k_ : someone needs shooting for that
<10> I have a list of names and I need to input a range of the first letter of the name. How do I find the inverse order of the name (ex. ascending and descending of the name - a-z and z-a)
<9> the table is already in the database as that and there is a tool that edits the database in that format
<0> phr33k_: try adding [] around it.
<9> gunther, i agree
<0> around the whole table name.
<9> okay ill try that
<10> can anybody pls help me with my question, above?
<9> ****ing awesome
<9> [] worked
<4> damn, but it looks like school is in session again
<9> thx a lot man ive been trying to look up the answer on google for hours
<0> np
<4> HanifUnix : did you read the rules?
<10> it is not homework?
<8> reading the rules is for... people who do their own homework!
<10> its a project
<8> what kind of project?
<0> so you want names where the first character is A..D?
<10> they input to upper bound and lower bound - for instance - entering a letter between z-a or a-z should output the name between a-z or z-a...
<0> HanifUnix: I haven no idea what you're trying to do... best of luck...
<11> HanifUnix "a-z or a-z" is not a for instance
<10> okay
<11> it's confusion on your part
<11> erm
<11> "z-a or a-z"
<10> Prompting the user for upper and lower bound - Name range begins with: and Name range ends with:
<11> HanifUnix we don't do homework
<11> this sounds like school work
<7> so how can i test if it is idsjoint?
<10> so I type a and z and it works..however if I type z and a it does not output
<10> like I said, its a project
<11> like I said
<11> it's school work
<11> which is no different than homework
<11> you want homework done then pay somebody or ask your teacher
<4> HanifUnix : paste the sql that does not work. state your rdbms
<10> hmmm, ok
<11> that's why you pay to go to school
<4> HanifUnix : like is says in the rules
<10> ok hold on
<6> crap...
<6> anyone know a good oracle quick ref? I need to alter an oracle table and I forget the syntax
<11> try 'alter table'
<6> heh
<6> ok, I'll 'try' that
<12> say my categories are equal = "Select Category from table where ID = 'foo'" and then Select
<12> i then need to select all values from another table that are equal to my categories
<12> can this be done in one query?
<13> not in mysql
<12> mssql
<12> sorry
<12> i need a subquery, right?
<14> so you want to get all items, with category names?
<14> i don't understand what the relationship is with this "other" table
<12> every item has a category name
<12> but it has to be the category pulled
<12> from the first query
<12> i have a product id and i want to find it's accessories
<14> you can just join most likely
<12> oh yeah
<12> probably
<14> <12> i have a product id and i want to find it's accessories <-- this seems like a different problem to me than the thing about categories.
<14> that's just select * from Accessories inner join ProductAccessories pa on (pa.ProductID = @productID)
<12> hmm i dont think that's it
<12> i will explain it in full
<12> i have one products table containing product ids, descriptions, categories
<12> that one table contains product but also some of the products are accessories
<12> the guys that made the db are dumb
<12> regardless
<12> i had to make a look up table
<12> that would match the categories of products with the categories of products that are actually accessories
<12> ex:
<12> product id x is a control panel
<12> product id y is a keypad for control product id x
<12> in the look up table called accessories i have: product_category 1 and product_category_2
<14> ok so select * from Products p inner join Products acc on (p.ID = @productID and acc.Category = accessory)
<12> great!
<12> thanks
<14> same concept, but instead of joining to accessories you join to products and filter out everything but accessories
<14> np
<14> how do i execute a DTS package from isqlw.exe?
<6> you still there?
<6> DTS from query analyser?
<6> save the DTS as a VB and then do a sp_cmd_exec type thin maybe
<15> how should i specify the columns of a table i'm creating that will do a 1 to many relationship?
<15> the column that references the many, that i
<15> is
<14> specify where?
<14> wha?
<15> like... i want one column in a table to reference possibly many columns in another table
<15> how do i do that?
<14> just make it an int, and create a FK constraint
Return to
#sql
or
Go to some related
logs:
#politics
#windowsxp
song yalla ma3a elsalama
#politics
#computers
overlaying calendars sharepoint
#politics
#solaris
libgnomevfs-CRITICAL **: gnome_vfs_mime_application_supports_uris
#linux-noob
|
|