Viewing 15 posts - 5,116 through 5,130 (of 7,484 total)
Steve Jones - SSC Editor (11/28/2011)
I'm baaaaaackkkkkImmunity granted to all problems in the Thread over the last week.
Haaaaaave you been conversing with too maaaaaany lambs away?
No way
Because they had...
November 28, 2011 at 7:29 am
Kiara (11/28/2011)
Evil Kraig F (11/22/2011)
Koen Verbeeck (11/22/2011)
L' Eomot Inversé (11/22/2011)
...I like your signature by the way. One of those universal truths 😀
Pourquoi contredire une femme ? Il est tellement plus...
November 28, 2011 at 7:13 am
Disgraceful trick question - it's not about the topic it claims to be about.
However, the utterly wrong explanation suggests that maybe the author didn't even realise that, so...
November 28, 2011 at 2:53 am
Depends where I am. In Western Europe I like a fishy snack - boquerones in vinegar and garlic, or smoked mackerel, or smoked trout. In India some rice...
November 26, 2011 at 4:51 am
People who are easy to work with find me easy to work with. In fact most people find me easy to work with. On occassions I can be...
November 26, 2011 at 4:19 am
You need to use the SAVE TRANSACTION command. You need to use it twice if you also want to avoid an error in the insertion to mynewtable making the...
November 26, 2011 at 3:42 am
Bill Hansen (11/25/2011)
CREATE PROCEDURE uspCategoryInsert (
@LanguageId AS INT
, @CategoryName AS VARCHAR(100)
)
AS
BEGIN
BEGIN TRANSACTION;
BEGIN TRY
INSERT INTO category...
November 26, 2011 at 3:11 am
Have you tried clicking on the red exclamation point icon (execute) instead of the green right-pointing arrow icon (debug)? I've never tried looking at a 2000 database from 2008...
November 26, 2011 at 2:30 am
Well, a random choice led to the wrong answer, so I got 0 of the expected 1.75 points.
November 26, 2011 at 2:13 am
An excellent little item.
This is one of those areas where MS documentation is almost completely useless. It also appears to be an area where the interfaces is a convoluted...
November 26, 2011 at 2:05 am
martin.whitton (11/25/2011)
The MERGE statement is only available in SQL Server 2008 and later.I don't think this has any bearing on the low percentage of people getting this right, though...!
Actually the...
November 25, 2011 at 9:20 am
Good question and good explanation - and thanks especially for the link to a late draft of the SQL 2003 standard.
It was a bit hard for a Friday question, just...
November 25, 2011 at 9:11 am
The supposedly right answer is a lot less wrong than the other options, but is perhaps not strictly speaking correct.
The page referenced explicitly states that as well as...
November 24, 2011 at 8:27 am
Looks like a bad answer to me.
From the Bol Page Starting Report Builder (SSRS 2005 version):
Because Report Builder is a Web application installed on your report server, you can use...
November 24, 2011 at 7:28 am
Revenant (11/23/2011)
Tom, I love your new tag line.
I love it too - but there may be otheres (perhaps of a different gender persuasion) who don't like it, so I'm keeping...
November 23, 2011 at 5:26 pm
Viewing 15 posts - 5,116 through 5,130 (of 7,484 total)