| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> that is sortable and only down to the minute
<1> why does everyone need to be spoonfed
<0> sorry :/
<2> i was using CONVERT(CHAR(16), u.DateRecorded, 120)
<2> spoon fed, i'm sorry?
<2> yours works too tenfour, thanks
<3> hi
<3> im using mssql how can i find out what databases i have ?
<3> using query anaylser?
<4> is it not immediately obvious upon opening query analyzer?
<3> i mean in a query
<3> return a table with all the databases
<5> this isnt sql.. but server related.. is there a way to backup my IIS 5 metabase so i can restore it on a clean server install
<6> ask #iis
<5> it does not exist.. but thanks
<7> select name ,* from sysdatabases
<7> but you have to be in the master database
<7> BOL: system tables
<8> I've installed Microsoft SQL Server, but I can't connect to my computer
<3> lol
<9> i had a quick question about rotating data
<9> if anyone is here....
<10> rotating data?
<11> pivoting?
<10> swinging?
<7> give a SPIN!
<9> can i paste in here?
<9> no
<9> ha ha
<9> 1 sec
<10> http://sql-servers.com/nopaste
<7> sure if you don't mind getting kick/ridiculed/banned
<7> these guys are *especially* proud of thier ridicule...real top notch stuff
<9> http://sql-servers.com/nopaste/?show=523
<0> i don't get it
<7> see what I mean
<7> ?
<9> http://sql-servers.com/nopaste/?show=524
<9> there we go, i updated my query statement
<10> looks more or less like a self join
<9> <<< confused
<7> looks like you need two queries in a union one for the child tables one for the parent tables, then union them to get your output like that
<9> do you have a sample
<7> and subqueries to get your 'extent' values
<7> BOL: union
<7> and no, I'm not going to write it for you...maybe these guys have time
<12> nice
<7> http://sql-servers.com/nopaste/?show=525
<7> call me a nice guy
<13> yes me harties i have returned :)
<1> look who is back
<13> yups :)
<13> miss me ?
<13> :P
<7> maybe this: you know I've never put any code in production that required a UNION
<7> http://sql-servers.com/nopaste/?show=526
<3> if i have a computer running windows 2003 x64 and mssql2005 x64 can i move data from a computer running windows 2003 x86 and mssql2005 x 86 to hte 64 box?
<12> I would think so but I am not certain
<7> wow, sure if you do it through the network, I don't know about files on drives though
<12> Binaries wouldn't work
<3> damn
<7> should be able to connect the boxes through a network and do it that way...hopefully they aren't too far apart and you don't have a ton of data
<7> ..or it may take days
<3> binaries wouldnt work?
<3> like doesnt amd64 run 32 bit apps in hardware?
<12> If you copied like a whatever.exe from the 64 bit machine to the 32 bit machine it would crap out
<3> i mean from a 32 bit to 64
<12> Probably it will work if its for both but stuff made specifically for 64 bit won't
<12> Oh
<12> 32 to 64 no problem
<12> back to watching ER
<3> even mssql is no problem?
<14> i'm using mysql. i've got one table setup so far called users (id, username, p***word) -- i'm coding a blog/forum thing and i want to do it right the first time. how should i setup the tables for user's posts? consider these will end up as threads.
<14> should i use one table called "posts" with id (int), post (text), and a null optional field called replyid (int) which references to records in the same table, to form a kind of recursive thread?
<15> are uniqueidentifiers unique only within a table or across the whole database -- across multiple tables?
<16> Theorectically, they're unique always
<0> universally
<0> the chance of getting 2 identical is so low that you'd have a higher chance of winning the lottery and being able to quit your dba job anyway, therefore it is safe to use 100% of the time
<13> so how is everyone ?
<17> urgh, i so do not want kids...
<17> listening to my neighbor yellin at his.
<18> Is there any reason why, when using ms2005, why when a parameter is set, its full value is not stored? im using Varchar(20)/nvarchar(50). If i send a value of "TEXT" i seem to get stored "T"... any suggestions?
<0> what is the insert statement
<0> the actual text sent to the db
<18> well, im using parameters and sprocs... so: INSERT Into Tutorials_Content (Title, Text_Full, Text_Short, Type, UpdateDate) VALUES (@Title, @Text_Full, @Text_Short, @Type, getDate())
<0> did you verify that the variable is "TEXT" when that statement is called?
<0> in other words, if your column is varchar(20) and you insert 'TEXT', then it will work
<0> so the error is probably before insert is called
<18> Thats what i am doing, i checked the code that sets the parameters, and as i see it, its fine... Its value is "TEXT" before anything happens... WHen cmd.ExecuteNonQuery runs, im unsure what happens. What i do know though, is if i change the datatype from varchar -> TEXT it works fine...
<10> change one of those parameters to be a literal string, and see what it inserts
<18> Well, i went into my sproc just now, and changed the parameters to 'ASDF', 'ASDF' and it stored properly
<0> what is the datatype of the variable
<0> the parameter
<0> whatever
<18> varchar...
<0> there's your problem :P
<0> make it the same datatype as the column
<18> they are all the same type.
<0> varchar(20)
<0> nvarchar(50)
<18> i was using those as examples
<18> I tried them both
<18> Right now, the parameter stores as VarChar(20)
<18> my SPROC says @Title varchar
<0> you are not listening
<0> make it varchar(20) if that's what the column is
<0> make the length the same as the column
<0> or else it will just store 1 char
<18> I have to declare the size in the sproc?
<0> yes
<18> OOOOH
<18> hahaha
<18> Thanks ;) ITs not that i wasnt listening to you, i just misunderstood you...
<0> no prob =)
<18> testing now.. gimme a sec ;)
<18> That seemed to work!
<18> I thought the sproc would have some default value... that was my mistake though
<18> Tnx again ;)
<0> np; good luck
<14> what's the best book out there for mysql
<14> specifically i'm looking for information on primary, index, unique keys, what it means, etc.
<19> If I have a web application, and I have to load some data to display on all the pages (this data is different for every user), would it be totally inefficient to keep querying the database for this information every time the page is requested?
<0> Zoom1 no that's completely normal
<0> the data has to persist somewhere
<19> yea, I'm kind of thinking that.. but it just seems really inefficient
<0> if you persist it outside the database, you would have to deal with synchronization issues
<0> and basically a whole level of premature optimization
<19> and the database generally caches the request so if the same request is made often, it's not so inefficient?
<0> essentially yes; the database already has a ton of optimizations that are directed at exactly what you're doing
<19> ok, thanks a lot
<13> what is the benefit of using php with sql ?
<0> are you trolling?
<13> like is it for websites ?
<13> so who's around ?
<13> i feel like being kicke din the face :)
<20> hi, XenReborn, what's up?
<21> you know whats crazy
<21> i just found out we got an extension to my homework and its not due until monday now
<21> hah
<21> oh well
<22> heh
<20> so you'll have more time between now and then to increase mastery of the concepts
<21> exactly
<21> i still need to go other all the problems and make sure my answers are perfect :D
<20> keep coming back
<23> I am using oracle sql and am trying to do a average of all the sums of 2 columns
Return to
#sql
or
Go to some related
logs:
$IsReg definition mirc
#computers
#linuxhelp
etkalmna
#photoshop
#solaris
#beginner
#beginner
#computers
phpdesigner2006_setup
|
|