| |
| |
| |
|
Page: 1 2 3
Comments:
<0> so that i see stuff like 2000-01-04 12:00:00 AM
<0> is there some way to suppress the time stamp?
<1> in sql 2005 is it possible to rebuild all indexes on all tables
<1> (with one statement)
<1> maintenance plans
<2> peano it stores the whole date+time you can view it however you like
<3> using ms-sql, how can i p*** an sp parameter as two strings concatenated?
<3> sp_Blah @var1 + @var2, @var3
<3> please tell me there's a way
<4> What's wrong with that?
<3> it says Incorrect Syntax near '+'
<5> (select @var1+@var2)
<5> maybe
<5> it's worth fixing properly though
<3> what do you mean?
<5> properly == declare a third varaible that is your parameter. Set it to @var1+@var2.
<3> i can't
<3> @var1 and @var 2 are varchar(8000
<4> Nope, no choice, gotta make a third var
<3> i can't create a local text variable
<4> Even if the syntax was valid it would still concat
<4> er, truncate
<3> no
<4> varchar(8000) + varchar(8000) = varchar(8000)
<3> i have a text variable as one of the parameters of the sp i'm calling
<4> But the syntax isn't valid, so you have no real choice.
<4> Yes, but it would have to concat before calling the sproc, if that syntax were valid.
<3> t-sql allows you to have a text variable as a sp parameter
<3> oh
<3> wtf am i going to do?
<4> What are you calling this sproc from?
<5> 2k5 does.. at least i read it does..
<4> 2k5 has varchar(max), you wouldn't use text
<3> i'm in a stored proc calling another sp to send an html email
<3> i need a large variable (+8000)
<4> There was a trick for doing this. If I recall it involved pushing the email body into a temp table and using that table in a query with xp_sendmail
<3> ah ha
<3> should the temp table just contain a text field?
<3> and throw all the data into it?
<6> how do i alter a field, setting an identity? i tried alter table <table> alter column <field> int IDENTITY and that doesnt work
<6> also tried identity(1,1)
<6> MSSQL btw
<6> all the examples i see just use the word identity, but i must be missing somewhere
<6> something* somewhere
<6> everyone afk? hmm what would it take to get people to pay attention....BEER AND STRIPPERS!!!!
<4> No good. We're all celibate mormons.
<6> damn :)
<7> Did you read the bol help for alter table?
<6> yeah, first place i checked, it says use the word identity unless my going on 4 hours of sleep *** read it wrong
<6> i'm starting to think i cant alter a column with identity
<6> only drop/add
<7> Did you notce a fundamental difference in the allowable arguments for ALTER COLUMN vs ADD ?
<6> but i cant lose the info
<6> i dont see why i cant do with SQL what i can do with enterprise manager
<6> it seems awful silly
<4> You can, you just don't know what EM is doing.
<7> Enterprise manager makes a temp table, copies the data, drops the old table, makes a new one, and copies the data back.
<7> click "view script".
<4> If you clicked that script changes button you'd notice that it makes a completely new table and copies the **** over
<7> Instead of just save.
<6> hmm
<7> Granted, sometimes EM does **** the hard way for no particualarly good reason ... but not this time.
<6> ok, i suppose i'll have to make a tmp field first and copy it over :) thanks guys
<4> field? no, table.
<6> well either table and field or field then rename
<6> i'm guessing either would work sufficiently
<7> You can rename fields? ;)
<4> Sure, but you can't update an identity field
<7> You can if identity insert is on.
<7> Although I didn't know you could rename fields. Guess I should read the help too.
<4> I don't think that permits updates, just inserts
<7> hm. COuld be a good point. I've never had to update an ideniity field, so I don't know for sure.
<7> The office 2007 UI just looks weird to me. I'm not sure I like it.
<6> 2003 looked weird to me also at first, why is it drastically different?
<4> quite
<4> toolbars go byebye
<6> no toolbars? wtf lol
<7> No menus either.
<6> what do they have, the paperclip running around the screen asking you what you want to do?
<4> http://blogs.msdn.com/photos/jensenh/images/547386/original.aspx
<7> Its all tabs.
<7> Really strange.
<7> Also: http://blogs.msdn.com/photos/jensenh/images/547376/original.aspx
<7> Which shows more hotbuttons.
<7> Been thinking about getting the beta, but not sure it'll play well with my office xp install.
<4> Probably not. That's what VMWare is for.
<7> More effort than I want to put into betaing MS' software for them.
<8> i love vmware. its one of my favorite windows related apps =)
<8> "hi, i need a server for this project." sure, itll be the indentical configuration as your last one, same cpu and memory resources too "great glad we have the space in the datacenter for a new server" muahahaha
<7> I have a win 98 and a dos vm, for maintaing legacy apps. So, no 2000 or xp vms already setup, and I'm certainly not going to do it just to test out a new version of office.
<8> im removing 7 racks of servers with a few vmware boxes
<6> yeah looks kinda wierd
<6> and yeah i'm not going to spend the effort to beta it, just like i'm not with IE7 hehe
<7> I installed ie7, just to see if it did css any better than ie6.
<7> It doesn't.
<7> So, still not using ie.
<4> They fixed a lot of CSS bugs in IE7
<7> The test css than I ran through it that renders perfect in ff still came out like ****. This was a couple of months ago, though, so I guess they could have fixed more since then.
<6> ms are jerks for trying to make their own standards, but some of the things they do make sense, besides i'm a web developer and i have to support it whether i like it or not
<8> yeah you have to support yet another image type
<4> Standardization is largely a farce.
<8> because wmf went so well
<4> Particularly since standardization usually occurs while products are already developed and deployed.
<9> how do i not list articles with datetime older than 1 month?
<4> By using a WHERE clause?
<9> WHERE DATE ... ?
<7> ugh.
<7> Sorry, if you can't figure this out on your own, you have no business doing database stuff anyways.
<9> faster to ask
<4> Not today it ain't
<7> Faster to be less ****ing lazy.
<4> Virtualization will be nice with the new enhancements to the Intel and AMD CPUs.
<8> until the expoit tools become better at breaking out of their VMs
<4> True.
<8> i saw one idiot trying to host webservers with vmware player
<8> he got owned :P
Return to
#sql
or
Go to some related
logs:
#visualbasic
#delphi
Metadata file does not match checksum
#beginner
janeydorr
#dsl
#politics
#mirc
#freebsd
#flash
|
|