| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> agreed.
<1> anyone have any comments regarding Python's SQLObject vs SQLAlchemy wrt stability, ease of use, and abstraction design?
<2> Fly_Mario: have you seen the new novell os?
<2> looks amazing
<0> not yet. Been to damned busy
<2> we tried to set it up on a couple of machines here, they were not happy about it.
<2> but it does look amazing
<2> I think the next step is to try it on a clean box
<2> not try and update an existing on
<2> e
<0> sounds cool.
<0> I'll have to give it a try
<3> howdy ho
<4> where do i find the SP in SQL 2005?
<4> Whats a good general SQL book?
<4> language wise
<5> something in english probably
<4> hehehe
<6> are you an experienced developer moving to sql, or are you a new developer period?
<7> TheGamble - you couldnt tell from the questions he's asked over the last seval weeks?
<6> haven't been on much last several weeks enough to notice :)
<4> new
<4> relatively new
<6> Ok, then a "Sam's" book is probably in order just to get you going, especially for "general SQL"
<4> cool thank you
<4> not the SQL Bible huh?
<6> Here's a decent starter for $10: http://www.amazon.com/gp/product/0672325675/104-9075994-0309540?v=glance&n=283155
<6> Those "Bibles" tend to be a bit much for neophytes
<4> thats the one i was looking at (Sams)
<4> ok i'll get that thanks again
<6> SQL Bible is 831 pages, not exactly an intro.
<6> Try it; what the heck, 10 bucks; then you can always get Bible or some other reference; what you really need is a tutorial
<6> Also, there are plenty of online SQL learning resources just as nice as the Sam's book
<4> anyplace specific for resources?
<6> I usually say W3Schools as a jumping-off point, but they're a little dry
<8> very
<8> and very shallow imo
<6> ;)
<6> indeed
<6> better is something with a little 'fun' factor
<8> get sams teach yourself sql in 21 days
<4> now the sams book is TSQL (whatever that means)
<6> yeah, that's a good one
<8> and then the one by
<8> whats his name. cooks or something
<8> sql for smarties
<8> Gm0nEy no its generic sql
<4> cool
<6> sql for smarties is Joe Celko
<8> that's it
<8> for tsql you want books online
<4> whats tsql?
<6> Celko PWNS, so to speak, but his approach is not really n00b-friendly, and gets heavy on theory sometimes
<8> Gm0nEy microsoft sql server specific
<8> TheGamble yeah. after sams :)
<6> heh, yeah :)
<9> ken henderson, guru's guide to tsql
<4> k thnaks
<9> great author
<8> a must if you want to really learn
<9> no jokes, no bull****
<6> Gm0nEy, you going to be designing the databases, or writing queries against pre-built ones?
<4> i designed one
<4> it works ok and the queries also but i want a better grasp of the language an stuff
<6> design is a discipline in and of itself, somewhat separate from the practice of writing queries. In other words, you need to study the relational model, set theory, etc, before you can design 'proper' databases
<6> proper databases usually involve trivial queries, and vice versa :)
<6> For example, when I design an OLTP system, you can usually employ a 7-year-old to write the CRUD procedures. This is sadly untrue with the vast majority of designs I encounter in 'real life'
<6> test: I'm having connection trouble today...am I getting through?
<4> i think my design is lacking in some parts but my queries are simple and they do get the results i want
<4> but there is always much more to learn
<9> positional column notation only works in order by, correct?
<9> sqlserver
<10> anyone know how to take a database ive modeled in visio and actually create the tables through odbc?
<11> Hi, I have a question.. Im trying to convert this sql query from our shop floor control program to a mssql query and some of the values are vaild functions in mssql here is the orginal sql http://sql-servers.com/nopaste/?show=313 and here is my converted one http://sql-servers.com/nopaste/?show=314
<11> where im stuck is where it compares the DateValue to Datevalue(now) not sure how to convert to mssql
<11> since datevalue isnt a mssql function
<12> what
<12> i dont get it
<11> the query inside of the shop floor doest work inside of msql
<11> so it needs to be changed around a little
<11> but on the line FROM AttendDet WHERE ActClockOutTime="99:99" AND AttendCode <> 9999 AND
<11> DateValue(TicketDate) = DateValue(Now) AND EmplCode NOT IN (SELECT VAl(EmplCode)
<11> thats not a msql function
<11> trying to convert that line inside of mssql
<11> still dont make sense?
<13> Leaderman just changing functions and words around isn't a good way to port something if you intend it to work the same
<13> you need to understand every datatype and function in both sql variations
<13> to know the equivalent
<13> you might want to look at getdate()
<11> I think that datavalue is actually something stored in the program(varible)
<14> Sounds like it might be trying to strip the time portion from the date
<14> There are a couple of ways to do that.
<11> ok
<12> o rly?
<13> quant you noob
<13> :/
<14> If you want a literal of the current day you can use { fn CURDATE() }
<14> It's an ODBC function that MSSQL understands
<14> Otherwise you can use CONVERT twice to convert to a date string and back to a date
<14> You could also cast to an integral type and back to date
<11> so use like a val
<12> not rly
<14> CAST(CAST(@d AS BIGINT) AS DATETIME) works
<11> hrmm
<11> still stuck
<11> not sure where to go from here
<4> a dubm question
<4> lets say i have a row
<4> and a column in that row is a file name
<4> 99% of the time this is the case
<4> the exception is when there are audio files
<4> there are multiple files
<4> how would i get around that is there a way to create a plce holder ?
<4> or i would just use commas?
<14> Do whatever the reverse of how you stuffed the files in there.
<4> well now its on file name per cell
<4> like the column files has a file name in each cell
<11> datediff(d, ticketdate, getdate())
<11> could use that instead couldnt i
<12> jeez
<4> can i somehow connect the cell that has to contain multiple files to a seperate table?
<12> you are really bad at specifying what you need
<12> why not just have two tables
<12> Items (ItemID), Files (FileID,ItemID,Filename)
<14> um, a column doesn't have multiple "cells"
<12> hehe
<14> If it wasn't for my horse I wouldn't have spent that year at college.
<11> datediff(d, ticketdate, getdate())
<11> could use that instead couldnt I .. to strip the date
<11> inside of and datevalue(ticketdate)=Datavalue(now)
<11> err instead
<14> WHERE (ticketdate >= CAST(CAST(GETDATE() AS BIGINT) AS DATETIME) AND ticketdate < CAST(CAST(GETDATE() AS BIGINT) + 1 AS DATETIME))
<14> I wonder if the cast method is more efficient than the convert to/from varchar method
<11> hrmm didnt throw a error but got no results
<11> lol
<14> Sure you have tickets for the current day?
<14> hm, interesting, the cast method rounds. That's problematic.
<14> WHERE (ticketdate >= CONVERT(DATETIME, CONVERT(CHAR(10), GETDATE(), 112), 112) AND ticketdate < CONVERT(DATETIME, CONVERT(CHAR(10), GETDATE(), 112), 112) + 1 AS DATETIME))
<12> ehheh
<12> why not use BETweEeN
<11> well the old code says - Datevalue(ticketdate) = Datevalue(now) AND emplcode Not In (select VAI(emplcode) From Online Where VAL(online.emplcode) = Attendet.Emplcode)
<14> Quant: BETWEEN is exclusive
<14> er, inclusive
<12> then no +1 and u good :)
<14> You'd have to pick an arbitrary amount of time behind the next day.
<11> so use....
<11> SELWHERE (ticketdate >= CONVERT(DATETIME, CONVERT(CHAR(10), GETDATE(), 112), 112) AND ticketdate < CONVERT(DATETIME, CONVERT(CHAR(10), GETDATE(), 112), 112) AS DATETIME))
<12> will PAL work on most CD players?
<12> DVD*
Return to
#sql
or
Go to some related
logs:
#red
#cisco
#nhl
#computers
spinwrong
#debian
#gentoo
#hardware
C preprocessor /lib/cpp fails sanity check
materiallibraries mat
|
|