Kinder?, Gentler?, or perhaps just being way too nice?
Welcome to Stack Exchange, Eduardo. Wow, what a "wall of code" you've posted - it would be really great if you could format that a little nicer - take a look at dba.stackexchange.com/help/formatting for details on how to do that. Thanks! — Max Vernon5 mins ago
I need to know if there is any method for intentionally corrupting an index in PostgreSQL.
I have been searching for it for a long time but never seen anyone mentioning such an act.
I am getting error while populating the values in drop down list using php postgresql. Error means no output in drop down list.
Below is my code.
<!DOCTYPE html>
<html>
<body>
<form name="form1" id="form1" action="" method="post">
<select name="selectid" Id="select">
<option value="">--- ...
The round or truncate behaviour is described in CAST and CONVERT (Transact-SQL). Numeric to numeric rounds. If you want truncation, you have to ask for it.
@PaulWhite Sorry but I think i'm confused : Are you saying that the implicit type of 1.0000009 is numeric(8,7)? {which I understand} , and the implicit type of SELECT round(1.0000009, 6, 1) is numeric(7,6)?
Just sharing my thought , wouldn't it be better to nominee in SO ? since SO holds huge amount of SQL server questions ? Obviously it's because SO was created first.
I mean , there area lot of SQL questions which should be moved to DBA. and they aren't.
The Original question can be found here:
SQL Server 2008 R2: Problems after computer name change
I need to know if there is a way to modify the script found in the original question to allow for all instances on a computer. I have a situation where I have used an image to duplicate computers a...
@RoyiNamir They are completely separate communities - while there is some overlap in the two, being a SO mod doesn't mean you automatically move SQL questions to DBA
This is quite similar to SEDE Sql Highlighter is borked for aliases with single quotes which was apparently fixed in 2010. Mine is slightly different. If you look at my answer to http://stackoverflow.com/questions/9507404/sql-server-2005-database-dropped-how-to-find-out-who-did-it-when-it-happene...
Is there a way to type something in a comment that renders like this?
You'll need to escape it with a backslash - that is, the \ character.
I've tried various combinations, but a single backslash formatted as code seems to be impossible.
Can this be fixed, or can I be enlightened please?
A...
Absolutely, it's unfortunate, my experience with the tech preview was really good and I'm definitely excited about it. Such is life if you want something on day zero though. Glad Dell system recovery works, haha
Seems to be across manufacturers, too. Dell, HP, Acer, MSI, you name it
@TomV That was a big reason why I didnt just upgrade on my main laptop. I can't afford to have their VPN adapter (albeit 5 versions old) just stop working for my clients
I think I wanted to do that originally but I was using a Surface Pro 3 at the time and for some reason all the HyperV network adapters didnt play well with their VPN appliance. At random times, all the network adapters would fail and I'
@PaulWhite I approved it because the edit-comment indicated the editor was attempting to ensure the info was retained in the post, which I take as being in line with what we typically tell people when posting link-only answers.
@MaxVernon Yes and I can see why you would. Personally, though, I thought there were issues with the suggested edit that could be improved (and hence automatically approved).
What I should have thought about at the time is the fact that the editor made some effort to format the contents nicely, rather than just blindly copying it. And I was wrong, the reference was preserved.
@MaxVernon I'm still a bit in two minds. Moderating would require a lighter touch than I often have, and it's true I would miss some of that visible engagement. BTW I'm not trying to play the role consciously, so if I'm doing that it's my evil subconscious. I guess it's only natural when there's nominations and stuff going on.
@Colin'tHart Well as a (somewhat) impartial observer, I prefer that over the long boring draws of old. 2-2 heading into the fifth match would be perfect for me. No doubt you'd prefer 4-1 Aus?
I do enjoy watching Australia bowl, but some of their batsmen are tough to like.
This happens a lot: someone posts a question, others post answers, the guy never responds – clearly, they've abandoned their question. Now guess what? Someone has accepted my answer on SO one year and two months after it was posted.
There's more. I actually answered it one year and a half after the question.