Thanks for asking one I know without having to think about 🙂

NM, I read the forum... I got a point for that??? I almost feel guilty 🙁

LOL!!!

I had 3 choices

1. Wrong Answer

2. Right Answer

3. Wrong Answer

so I chose #2, the "Right Answer"... was this a joke question or did the webpage break??? 🙂

I would like to...

I should have known to avoid a question with version mixing , i.e. SSRS SQL Server 2000 😀

Got me! I chose 0 like everyone else using SSRS (2005 or 2008)...

I used deductive reasoning more than SQL skills to guess this right 😀

I assumed Number 1 would return both columns, the other 3 would return only column 2 and number...

Well, I guessed that it would cross join and got lucky 🙂

Now I have a new way to do cross joins! Can't wait to kill my server with that one...

Wow! The shocking thing to me is that I understood it and answered it right! Those T-SQL classes that I am teaching are starting to pay off 😉

petertrast (3/3/2010)

For DML, yes...

Or......

For DML, yes...

Or... CREATE,...

Because it is a DML event, the structure of the table is not changing, just...

Got me! I (improperly) assumed WITH CHECKSUM and chose the backup answer... silly me... thanks AGAIN Paul!

--The devil IS in the details... get out of there pointy ears, I'm trying...

I will have to remember to answer questions 2 weeks late all the time to make sure I have a well-worded question 😉

Thanks for the edits! I can't afford any...

Thanks for an easy one, I usually need to think alot more. Actually, I was surprised to see how many missed that one. I will be careful to cover that...

Not if you replace DATALENGTH with LEN in this query 😉 I have to try...

I did most of my learning from the posts. I think that makes it a good question (even if I made a bad assumption and lost a point). 😉