| |
| |
| |
|
Page: 1 2 3 4 5
Comments:
<0> irc ad spam. What has the world come to?
<1> you're luck you don't get more of it... there used to be more of it, I guess it was limited in sucess unless there was a porn URL attached
<2> guest1: I saw a relative of yours the other day, guest2
<3> does MsSQL accept dates as yyyy-mm-dd?
<4> not sure, to be safe just append it with "00:00:00"
<5> wtf kinda suggestion is that?
<4> read books online
<4> better+
<3> guess what? sql server 2005 manager displays it using that format
<3> got my answer
<1> haha phargle, thats my twin brother
<5> ?
<1> [14:06] <2> guest1: I saw a relative of yours the other day, guest2
<5> heh
<6> should i bother with separate ip_addresses and mac_addresses tables? http://pastebin.com/643039
<7> well mac addresses are arbitrary and changable... depends on the point of the application
<7> plus dont ask mysql questions here...
<7> and what about server that use bond# interfaces which really dont have mac addresses per say?
<7> and why do you have a mac_ip_id when mac addresses are supposed to be unique? why not just make the mac address the key? ;) something to think about
<6> Jarett_: we have some machines that use bonding/teaming - but there physically are two nics in them
<7> and?
<7> then you have 3-4 mac addresses for 1 ip
<6> well i call it mac_ip_map but the key should also depend on the server_id too i guess
<6> yes, macs can be set yourself and spoofed but it's more of a matter of tracking inventory and tracking scans what gets reported as real macs floating around the network
<6> so whether they are real or not, doesn't really matter for what i'm trying to do
<1> no, that looks fine, but that'd be an expensive table to maintain, I would think
<1> I don't adhere to the "full normalize everything" philsoophy
<8> select NumberValue from items i inner join Numbers n on (i.NumberID = n.ID)
<6> in this case it seems to mean more code to handle the inserts and selects
<1> sometimes I just want a nonlogged, nonindexed log table that inserts quickly and can be indexed/normalized later for reporting
<8> inner join Months inner join Days inner join Years
<3> any known reason why I get a "String or binary data would be truncated" error when trying to add a string to an nvarchar field in MsSQL?
<6> Guest1: hmm i think i'll do that. a good compromise. one table for logging antoher for report purposes
<6> i stick to the 'avoid premature optimization' philosophy
<6> i'm sure to someone here that translates to 'short-sighted' philosophy
<1> well, I've found that if you start with a fully NORMALIZED db design you'll be running into performance problems at some point. usually it's the fact tables that are high trafic and it's expensive to maintain all the little look ups
<7> Bronso, you arent taking character set byte sizes into account probably
<3> Jarett_ and how should I do that? all I'm trying to do is update a field with a short english string?
<3> I even set SET ANSI_WARNINGS OFF, but it won't help
<1> yeah, what jarett said, you've probably got a varchar(255) and a char(50) added and tried to insert into a varchar(255), most of the time it'll fit, but it'll warn you every time
<1> the insert works though, it's just a warning
<1> ...and if its too big it WILL get truncated, but the insert will still go
<3> It happens on UPDATE
<1> same story
<3> I'm ALTERing it now to be nvarchar(255), lets see
<1> why does it bother you so much
<3> Guest no, it doesnt get updated
<3> b/c in ASP it generates a warning that take the whole site down
<1> it should
<3> $hould
<1> hehe ASP, its funny that the .net stuff stops on ANY error
<1> the update probably did work but asp choked on the error
<1> use a try/catch block and DONT CATCH, see if it works
<3> ASP cl***ic :)
<1> heh
<3> n/m, changing the nvar to be with a fixed size helped
<3> I'm testing it now
<1> good thing both products are made by M$
<3> both? all of them
<1> ..otherwise they might not talk to eachother correctly
<1> </sarcasm>
<3> niiice
<3> ok, it worked
<3> book it is a new HOWTO, heh
<3> DONT use nvarchar without specifying its size
<9> how do you export data to CSV in SQLServer2005?? I'm having a tough time finding it
<10> Baz_ : bcp
<8> openrowset() ?
<9> guntherx, whats that exactly
<10> Baz_ : documented
<9> can u atleast give me the full name to search
<10> Baz_ : bcp
<9> google's gonna returnb a lot for: bcp
<10> Baz_ : bcp.exe
<10> **** google, bozo, read the documentation for the rdbms
<9> this cant be done using management studio
<8> it can be done with openrowset()
<8> like i already said
<10> Baz_ : you didn't specify management studio
<9> in enterprise manager you could right-click a table and export
<10> so?
<10> bored with this...
<10> l8r
<9> is there similar functionality in management studio
<9> i dont know why i ever come here to ask a question - everyone's goal is to show how smart they are and how stupid everyone else is
<8> yea you should definitely go elsewhere
<8> bye!
<11> bastards
<11> maybe you should attempt to learn before you do your job
<11> waaaa
<9> i am attempting
<9> u never asked a question before cojonesx
<9> u were born all knowing?
<11> im not saying I am, im saying at least attempt
<11> I learn alot from people on here
<9> i've been searching for 2 hours
<7> you need to learn how to search...
<9> it seems like a sinple thing
<11> the better informed you are about the subject the better answer you will get
<9> i'm sure every one of u knows how to do it
<12> paste
<11> @ bol
<13> bol = Books Online http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en#filelist ;Start - Programs - Microsoft SQL Server - Books Online http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp
<9> but for some reason u prefer trashing me than just giving it up
<12> paste?
<11> im not trashing anyone
<8> Baz_ you were the first to trash people btw
<7> http://www.google.com/search?hl=en&lr=&client=firefox-a&rls=org.mozilla%3Aen-US%3Aofficial&q=%22sql+server%22+%22export+csv%22&btnG=Search
<7> link #1...
<14> Jarett_ how did you do that
<14> amazing
<11> OMGWTFGOOGLE!
<14> CoJoNEsX you should change the topic to "Google - The best kept secret on the internet"
<9> so basically u are answering part of my question -it is IMPOSSIBLE to export data to CSV using managmeent studio
<14> haha
<11> that wasnt even your question Baz_
<12> k i realize I have absolutely butchered mt case statement and that there is probably a more intelligent method of doing this...http://authors.aspalliance.com/aylar/ViewPasteCode.aspx?PasteCodeID=5508
<11> <9> how do you export data to CSV in SQLServer2005?? I'm having a tough time finding it
<12> mt=my
<9> cojonesx, if read a little lower u will notice: this cant be done using management studio
<9> ?
<9> and apparently thats when i crossed the line
<12> im confused though in figuring out how to interpret my param as numeric within my where clause... ie. if someone enters other than numeric, it should just ignore the FTE clause... can anyone ***ist?
<11> why not do it before you write your query then w***a? and have two queries?
<12> i suppose i could, but i was trying to just compile it to one. its for implementing on an intranet, and i guess it would save me having to read the request.form/qstring and then interpreting which query to run
<11> well you cant change a where clause to change the columns its on in the clause itself
<12> hmmm....
<11> you could maybe say where col1 = case col1 when isnumeric then thevalue else col1
<11> psudocode of course
<11> and bad spelling to boot
<12> yeah i believe i tried that but it didn't really fly.
<11> but if you dont need a where clause then dont use one
<11> that wouldnt return nulls either
<12> yeah i don't need nulls... this is just a super slimmed down online record search
<11> using a where when you dont need it will just lead to performance problems
<12> going off your first suggestion which seems most logical...
<11> im going home, later all
<12> ciao... thanks for ideas
<1> hahah: [15:34] <10> **** google, bozo, read the documentation for the rdbms
<1> what a sign of the times, huh? now if its not in wiki, top 10 hits in google, or someone hasn't blogged it, it never existed
<7> and now i realize that math teachers banning calculators wasnt all that bad...
<6> hmm if i have a table of mac addresses, why bother with a mac_id and why not just use the mac_addess?
<6> oh wait, that's what Jarrett_ said before
<7> imagine that...
<6> is there any big advantage to an integer as a primary key?
<7> since, characterset compatibility
<7> s/since/size
<6> no mysql questions here - but why? doesn't it now have a lot of the major features it used to lack?
<8> because there is a whole channel for it
<8> #mysql
<8> it's part of the total cost of ownership for a wannabe free database
Return to
#sql
or
Go to some related
logs:
#windows
unregister nero scout
#windows
#windowsxp
#qmail
#cisco
#rhino3d
#gentoo
#rhino3d
delphi self.free suicide
|
|