SQL server exams - Coco's question of the week #8

Author

Coco's question of the week #8

cocolocopolo

2002-09-20, 12:30 am

RE: XML Support

What 'must' we do to the following code before it can retrun its result as an XML document?

Use Northwind
Go
Select t.territoryID, e.employeeid as 'EmployeeID', e.lastname,
e.firstname, t.employeeid
From employees e Inner Join employeeterritories t
On e.employeeid = t.employeeid
Where t.employeeid = (Select min(employeeid) from employees)
Order By territoryID

2lazybutsmart

2002-09-20, 1:42 am

XML data, is produced by the T-SQL keyword "FOR XML", and is retrieved by the T-SQL keyword "OPENXML".

Now in your situation. inorder to produce that query as an XML document, all you have to add to the SELECT statement is:

"FOR XML auto"

try it out. you will get a XML result in your results pane.

necrophantasm

2002-09-20, 12:07 pm

2Lazy why don't you just take the tests and get em over with? You obviously know this sh**. Good job man, and good luck

2lazybutsmart

2002-09-20, 2:06 pm

thanks allloooooot necrophantasm. thanks for the encouragement.

I don't trust my knowledge alot. but i'll try. i'll go by your word.

but hey, how long did it take you to earn all those certs!!. you must be a real-guru.

best wishes,
2lazybutsmart

necrophantasm

2002-09-20, 2:43 pm

I got my first computer 3 years ago and passed my first certification test just over 2 years ago (A+ hardware in late August of 2000). Ever since I got my first computer it has been my passion. It is my hobby and my job. A pretty dangerous combination (just ask my fiancee). I take a about a test a month... some months more, some less but that is the average. However, I have yet to take a real vacation. My fiancee is now at the point where she wants me to take a break after every test, but I know I have a long way to go before I will be at that point. As soon as one is knocked out, I pick a new one the next day and start cramming. It got me into this career, and I am not about to stop now... I haven't reached my goal yet. How long have you been doing computers man? You definitely seem to have a thirst for databases. What is your goal?

cocolocopolo

2002-09-21, 12:02 am

Thanks dear 2lazybutsmart and necrophantasm.

2lazybutsmart

2002-09-21, 1:23 am

Looks like you've made use of your time. 3 years, boy oh boy, that's a small time frame for all those certs.

Anywayz, in my part, i've been into computers since the first 8086 came out. I had one of those machines since 1999, but after it turned out to be just a pile of garbage filling my office, i got rid of it.

I got my first cert (A+) in 1995, when there was no such thing as pentium II, III, or 4. nither windows 98. so my a+ cert is quite out of date.

Since then, i've jumpped onto the other side of the bank (i.e. programming, networking, etc.).

I've done alot in databases pratically since 1999. But I never had an instinct of getting at the exams until reacently. I've also done alot in programming with Vb 4.0, 5.0, and 6.0. a little bit of ASP, and web programming. and a little of report's designing etc. anywayz, it's been quite a long career for me despite my age. I've been into this thing since i was 10 years old.

My goal is, as soon as i'm done with MCDBA and MCT, probably i'll add MCSE. after that, i'll start university and i'll put I.T guru"ing" in a halt for a sec.

You are really a person that deserves attention. Probably we will see each other one day to discuss the future of I.T.

way to go necrophantasm,
2lazybutsmart

necrophantasm

2002-09-21, 10:12 am

Hey thanks for the words of encouragement man. You would be perfect for my company. We are a client/server based web company (100% Microsoft shop) that has created a system that helps freight forwarding companies track their shipping orders for importers/exporters. Everything is written in VB, ASP, and a little C. We use SQL for all databases, sounds to me like it would be right up your alley. My boss wants me to start doing programming soon so that I can help develop our products. I am not so sure that I want to (Cisco, Sun, and Novell are calling...), but I will end up doing it just for the versatility factor. I haven't made it to college yet either, and although I would love to, time and money aren't readily available enough to do so. It sounds like you made your career choice a long time ago. I am glad to see you have stuck with it through the years. You obviously have a lot of knowledge and experience, and if it hasn't paid off yet I am sure it will soon. Thanks for the kind words, I hope we do meet at some summit somewhere someday.

Sponsored Links