| |
| |
| |
|
Page: 1 2 3 4 5 6 7
Comments:
<0> my confession is that i use enterprise manager to create tables
<1> in mssql how do u get the current datetime?
<2> GETDATE()
<1> thnx
<1> how do u do getdate minus 5 minutes
<3> DATEADD
<2> and next question: books online
<3> yup :)
<2> dateadd, datediff and getdate
<2> there yo ugo
<1> thnx
<4> in sql server 2000, how do i suppress an error?
<5> execute correct statements
<2> some errors cannot be supressed
<4> is that an "i dont know" or a "i wont help you"?
<0> why would you ever want to suppress an error
<5> it's "you didn't give enough information so what the hell do you want from me"
<0> errors should be fixed
<4> there are known errors in the system that are accounted for with other checks
<4> but there are unknown errors that crop up from time to time
<2> set the error level in the client
<4> so i want to suppress the ones i know
<4> and then check for errors in the output
<0> this is a client side problem
<6> You cannot suppress errors
<2> mssql doesnt abort transactions on "lowlevel" errors
<3> you dont suppress em, you check for them beforehand and dont execute code that will cause them
<4> let me say the following thing to everyone who is saying "there is no context in which suppressing errors would be useful"
<4> in sql server 2005 there is a try catch clause for this express purpose
<6> Yes, and SQL2000 lacks that
<4> however, i dont have 2005, i have sql server 2000
<3> yes, and youre using 2000
<2> its not to surpress it
<2> it's to handle it
<4> so im wondering if there is a more complex workaround
<6> Nope
<3> and were not saying its not useful, were saying theres no magic switch to do it
<2> and i suspect to handle 1205 mostly
<3> hence, you check beforehand
<3> or if its severity < 16, you pick it up via @@ERROR and handle it
<7> hi guys i got a problem with installing a script onto my sql server
<7> im getting a really anoying error
<7> The used table type doesn't support FULLTEXT indexes
<7> :S any ideas guys i really need to get this script working and cant find where to fix this problem
<3> did i hear yu say you were using foxpro ?
<7> no.......
<3> no, i didnt.
<8> Perhaps using MySQL?
<8> =)
<3> who knows, since he didnt say.
<3> shame, cos i was in a helping mood
<3> bbiaw!
<8> ooh ooh! flat files!
<7> yes mysql
<7> sorry
<7> i was afk
<9> and unable to read apparently
<7> ?
<7> im just installing a script........
<10> you shall perish in the depths of hell for using mysql
<10> have a nice monday
<2> haha
<2> that would make an excellent topic
<7> i do have sql server 2005 standard edition legal :)
<11> legal, nice
<7> i even have visual studio pro 2005 legal :)
<11> by legal, do you mean "a copy of someone else's legal"? :P
<7> no
<7> original :)
<12> is stephan hawking considered the smartest man on earth?
<8> No, that honor goes to Carrot Top
<12> carrot top?
<8> Si.
<13> hows it going all?
<13> http://66.80.138.163/EA6.png
<13> I'm thinking about using this structure for a project with a requirment that all entity's in the system can have their fields modified, removed and added at run time, including complex field sets (like mailing addresses)
<14> didnt learn the first time ? lol
<13> so Entity would contain a def for all applicable entitites in the system (they would have equivalnt tables with at the very least a uniqueidentitfier PK) and then Prototype would contain a defination of available field sets, PrototypeDefination the definition of those field sets
<13> EntityPrototype would define the protyped fields that each entity can have and their names, and prototypeinstance will store the values for each field foreach prototype foreach entity
<13> and then I'd create a View of PrototypeInstance foreach Entity
<13> (1) can anyone think of a better way to do this and (2) would the perform decent with large amounts (1M+ rows) in PrototypeInstance as long as I write the views right
<13> hey Arrakis, wsup?
<13> whats the comand for a new Guid in Sql Server
<13> NewId() ?
<15> hi. i'm writing a query for a work project where i want to get the rows in one table that are not in another table and only those rows. its mysql 5.0.4 (very cutting edge). I've tried using left joins but i think i'm lacking something here.
<15> what join can i used in order to show rows in the table1 that are not in table2 and only those rows.
<15> oops. rule 5 is no MySQL
<16> outer join
<15> but this really a query question than a specific db question.
<15> ok. i've tried left outer joins but thats no luck either. i'll try a regular outer join.
<15> i'll paste my query at the nopaste site.
<15> http://sql-servers.com/nopaste/?show=250
<15> just updated it.
<15> same url.
<15> err. its posting 251.
<15> hmm looks like using IS NULL has done it.
<15> although i'm still not convinced that its the way to go.
<15> thanks
<15> err its NOT the way to go.
<15> this should be my cue to go home.
<15> thanks
<17> ah damn no mysql lol
<17> #mysql is dead :|
<17> dunno if this applies to sql in general or mysql only, but what table type is considered "best"? InnoDB, MyISAM, ... ?
<6> Yes, that is MySQL specific
<17> ok
<17> bye :)
<18> why does SQL server take so long to delete rows?
<18> i deleted 45,000 rows from a SQL Server 2005 db and it took hours
<18> i dont even know how long it took i just went out to get a gl*** of JD
<19> because your query and or db-structure probably is less than optimal.
<18> drhyde_: no query, i just went into sql server management studio and deleted all rows
<18> how do i optimize the db structure?
<19> use a query and just do a 'truncate table' next time
<19> gui's **** for doing db work...
<6> It probably looped and deleted them individually.
<19> would be a decent guess, halo.
<18> i see
<6> Or could be other things, like an fk with a delete cascade
<18> no cascades
<20> i need an excel guru to help me use vlookup, index, or match or something to return multiple matches comparing 2 or more spreadsheets instead of just the first match -- I've tried importing into sql even
<20> Excel chan is silent atm so i thought i'd try my luck here
<10> there is no luck here
<10> this is sql
<21> darken
<21> how's it going
<10> not bad..
<10> just got done cooking dinner
<10> was awesome
<22> what is the command to reset/clear all the values in a column?
<22> for all the rows
<22> or a bunch of columns at once
<0> you mean delete them?
<0> truncate table x
<22> yeah
<22> no i dont want to delete all the rows
<22> just the values in that column, for all the rows
<22> for example, a table "phonebook"
<0> update x set column = null
<22> thanks ill try that
<22> ahhhh
<22> you the man
<23> woosh
<24> got an orcale question need to use dbms_metadata_util in a select anyone know how i grant permissions for this?
<25> good morning all
<26> yo
<26> dude u doing anything tongiht?
<25> SicLuDe:: j0... long time no see
<25> tonight? i am kind of busy today... since my supervisor is on a vacation..
<25> i gotta take care of stupid CTP machines...
<26> perfect time to take off :0
Return to
#sql
or
Go to some related
logs:
Chicken 3game
#computers
TITSANDASSES
#stocks
mytoz delphi
oobe.exe
stockhouseusa
virtua cop windowed
pipe a list of files into
Brak55
|
|
