I just find it funny when it says "Select all that apply" but the selections are made up of radio buttons, not check boxes. 😛

furthermore, they still carry it over to SQL 2008, so definitely intentional 😀

Interesting question, I got it right, but I don't think it's a glitch in SQL Server 2000 or 2005. in the Books Online (for 2005), it is mentioned in http://msdn.microsoft.com/en-us/library/ms186755.aspx...

The QotD seems to be getting a lot of mistakes lately. I didn't pick A because of the "dob" field, and didn't pick B as well from not thinking well...

I'm lost, I chose SQL Server 2005 SP2, but it tells me it's wrong, and the correct answer is SQL Server 2005 RTM. But the explanation and the links all...

The question doesn't specifically mentioned this is for SQL Server 2005, so I think we SQL Server 2000 users deserve some credit for answering "A" 😀

I agree with you. Even the first option "This returns all combinations of all rows in both tables based on the columns joined in the ON clause." is correct...

Yeah, my answered was reversed too. I answered false, now it says true.

You should try using the Books Online, it's a great resource to learn. They even have examples.

This is what I usually do:

--do something here

IF @@ERROR > 0

    RAISERROR('Your error message...

Use the RAISERROR function

CREATE PROCEDURE sp_myInsert1243

@odid12 int,

@rqty12 int,

@wqty12 int,

@rdate12 datetime,

@badge12 nvarchar(10),

...

I know that, but if there are more than 1 record with the same description, you will get all of them, example:

Part #1 description is "Radio"

Part #2 description is "FM...

Sorry, this is for SQL 2000, not 2005. Didn't realise I was posting under 2005

I think you can't do it is because the PARTID returned from table PART has more than 1 record. you should use the keyword IN

CREATE PROCEDURE dbo.MyProcedure

AS

SELECT DISTINCT O.ODID, R.RCID,...

Your network admin should know the LDAP server name.