| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> ok
<1> :)
<0> yes it is
<0> :)
<0> . /join #english
<0> :)
<1> can I make it inclusive for the first date and not for the second?
<1> without messing with the parameters
<0> Bronso: no
<1> :(
<0> between is always inclusive..
<0> u can just break it up by doing: where x >= start and x < ened
<0> end
<1> yep
<0> we should come up with some questions that people have to answer before they can get any help
<0> ya im that bored
<0> google is over 400
<0> again
<2> 400 what?
<2> oh stock
<3> itll be another commerceone :P
<3> or excite... or lycos... or altavista
<4> if i have a datetime datatype can i exclude the year?
<5> DATE_FORMAT()
<0> waht rdbms?
<4> ok so i would put the year in the table but format it later?
<5> what DB?
<4> db management system?
<4> sql 2000/2005
<0> it would be better to keep the whole date
<6> ub access, what data type would be enough for 1.0223E7 ?
<0> and then just format it later
<4> cool thanks
<0> oixx: look at hte help files
<0> woo hoo.. i have ran 3 queries all day today
<7> How does MSSQL Save a date in the field type SmallDateTime ?
<8> please ask questions that make sense
<9> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_7msw.asp
<9> Its amazing what you can find with google.
<7> That to me makes sense...
<7> lol
<10> knave, i believe its accurate down to the second only
<7> Drk`Angel: Tnx
<10> datetime is down to the ms
<7> thats fine.
<9> Its to the minute.
<7> second is all I need ;)
<9> As linked above.
<10> to the minute then
<7> or minute... technically half hour is fine
<9> It also rolls over in 2079, which really isn't that far away.
<0> 2079 is way too far away
<9> And, honstly, its what, 4 bytes?
<0> :)
<9> Whooptyfreaking do.
<9> jsut use a datetime.
<7> We wont need to worry about anything about 20 yeras from now ;)
<0> we wont even have computers at that point :)
<7> the application wont be used for more than 10yrs...
<9> uh huh.
<9> Heard that before.
<7> lol, it cant be.
<7> the nature of the program will not give it a life of 70 years...
<9> You're young, aren't you? :)
<0> and cmon... if people start using datetime.. then whos gonna make money off the y2080 armagedon?
<7> LOL
<9> You will be amazed at the amount of craptastical patching some companies will do just to avoid writing a new system.
<9> There's a reason why cobol programs are still in use today, and its not because they're fast.
<9> And ... like i said.
<9> 4 bytes per field. big freaking deal.
<9> Use datetimes, save later headache.
<7> lol
<0> no use smalldatetime
<9> Why would you want to use smalldatetimes? Seriously?
<0> im thinking of the future
<0> ill have something to do in 2069 :)
<9> hehe.
<0> if im still alive
<2> heh
<0> if not.. who cares? :)
<9> Ah well. So much for trying to convince him I guess.
<9> Gotta save those 4 bytes, might run out of disk space.
<0> totally valid concern :)
<11> i am wondering why "sp_depends" doesn't return dependencies for a simple "sale" table will someone check this out for me? http://sql.pastebin.com/640104
<12> good morning... im wondering if there is anyone in here who knows if there is a method in which to index/search MSSQL2000 specific tables within a db via ASP script. I could run a super duper query but i was really hoping there was an alternate method.
<10> d2d_w0rk, its not reliable
<13> d2d, your ddl looks fine
<10> if you just want to know what tables a table depends upon and which depend on it, i can post a script for you
<10> w***a, your question isn't clear
<13> I am curious about: info_date datetime DEFAULT (dbo.DropTime(getdate())) why not just DEFAULT GETDATE() ?
<13> not that it matters to your question
<10> for schemabinding perhaps
<10> or formatting the time, flattening it
<13> maybe it's a machine gernerated create statement
<11> hm.. thanks dfworking.. and guest2
<12> dfworking, i am referring to full text searching, much like a web search engine. whereas using run, would return results such as running, ran, run
<11> guest2:: it's just a test script for checking out the dependency.
<10> w***a, yes, and?
<12> do you know of any tutorial scripts or resources to implement this? im googling everyhing I can think of to find a sample script
<13> its just the first time I've seen that and wondered if there was a specific reason for it, I always just DEFAULT GETDATE()
<10> w***a, for using fulltext searching?
<12> my server admins will never install full text searching componenet
<12> component
<10> and you want what, an alternative to fulltext?
<12> well i suppose... but i guess that is not realistic without creating a catalog file... which means I would have to query the physical db every time someone wans to search for something.
<13> to tell you the truth, cold fusion had come with a verity text-search engine before MSSQL had fulltext and the jury is still out if SQL's is any faster, one thing I do know verity was a helluvalot easier to configure
<10> you do anyway with fulltext, its just that fulltext catalogs are outside the db
<12> yeah i understand that, but like i said...my server administrators will not install new components
<10> w***a, the alternative way is to 'tokenize' all of the words in your text and store them in a table with pointers to where they were found
<10> then you index that word column
<10> since there is a single word in each row, you can perform very efficient LIKE searches that use the index
<10> LIKE 'run%'
<10> understand?
<10> hold, i'll find an article discussing the technique
<10> sec
<12> yeah i do understand your logic, just have never undertaken a similar task to what you are referring...
<13> We are an Open Source Religion and everyone is welcome to participate in the development and improvement of our religion.
<13> hahaha
<13> oops wrong window
<10> http://www.sqlmag.com/articles/index.cfm?articleid=27195&;
<10> w***a, just sign up for a free account if you don't have one
<13> http://www.churchofreality.org/wisdom/welcome_home/ if you want a laugh
<12> how the heck do you get the free account
<10> they used to have a free account at least...
<10> blah
<12> its like trying to find free real player
<12> i think your article is pretty similar to this - http://www.databasejournal.com/features/mssql/article.php/3441981
<10> not really
<10> that talks about fulltext
<10> i was trying to point you to a way to not use fulltext
<10> since you said they won't enable it
<12> yours is the the 'tokenizing one' hmmm
<12> yeah.
<12> i can get the source, just not the article... blah
<13> funny
<11> sorry about that.. one of the servers went down and had to rush..
<0> sorry bout what?
<11> anyways, sorry about not mentioning my RDBMS which is sql server 2000
<11> SicLuDe:: dfworking and guest2 were helping me out on something but i didn't get to respond properly
<11> sup there SicLuDe :)
<11> anyways, it's my lunch time so ttylz
<0> lol do some work
<14> Wheres that crazzy nigga Quant?
<15> upinya
<15> everyone having fun in orlando?
<15> who all is there besides tz?
<16> yeah is anyone else here?
<13> well I suppose there are worse times to visit orlando
<15> like when your mom is there?
<13> spetember is horribly hot and humid
<15> HERPES FOR EVERYONE!
Return to
#sql
or
Go to some related
logs:
#beginner
detect flash tut
convert wmmp
#stocks
#mirc
mechillen
#stocks
setting mask in actionscript
install hellanzb invalid Python installation
#heroin
|
|