Viewing 15 posts - 316 through 330 (of 341 total)
Thanks for asking one I know without having to think about 🙂
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 15, 2010 at 9:32 pm
NM, I read the forum... I got a point for that??? I almost feel guilty 🙁
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 15, 2010 at 2:51 pm
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...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 15, 2010 at 2:50 pm
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)...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 15, 2010 at 2:41 pm
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...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 15, 2010 at 12:51 pm
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...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 15, 2010 at 11:19 am
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 😉
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 3, 2010 at 11:32 am
petertrast (3/3/2010)
SanjayAttray (2/6/2010)
Back to basics. Most of the time I select wrong answer for basic and simple question. Triggers are for INSERT, UPDATE, or DELETE only.
For DML, yes...
Or......
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 3, 2010 at 11:18 am
SanjayAttray (2/6/2010)
Back to basics. Most of the time I select wrong answer for basic and simple question. Triggers are for INSERT, UPDATE, or DELETE only.
For DML, yes...
Or... CREATE,...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 3, 2010 at 11:16 am
Christian Buettner-167247 (2/5/2010)
I wonder why there is no DDL trigger available to capture this of event...
Because it is a DML event, the structure of the table is not changing, just...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 3, 2010 at 11:13 am
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...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 3, 2010 at 10:33 am
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...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 3, 2010 at 10:18 am
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...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 3, 2010 at 8:54 am
benkoskysa (3/3/2010)
With the given SQL, @temp is an empty table, therefore count(1) will always return 0.
Not if you replace DATALENGTH with LEN in this query 😉 I have to try...
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 3, 2010 at 8:46 am
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). 😉
Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
March 3, 2010 at 8:11 am
Viewing 15 posts - 316 through 330 (of 341 total)