forget

When I read the book "teach yourself SQL in 21 days", day 7, first example:: SELECT * FROM TABLE1 WHERE TABLE1.SOMECOLUMN = (SELECT SOMEOTHERCOLUMN FROM TABLE2 WHERE SOMEOTHERCOLUMN = SOMEVALUE) When I tried this subquery, it doesn't work in SQL-server 2000 at all ! After that I searched online, then found that I have to use "IN" instead of "=" to express the subquery. I am confused ! Why the book writes like that? Is this an old SQL ? SQL is supposed to be universal, why I cannot use above example in SQL2000? I also found some other places which is not wworking in Sql-server 2000 environment. Please help me on this silly question. Thanks Dennis

:confused:When I read the book "teach yourself SQL in 21 days", day 7, first example:: SELECT * FROM TABLE1 WHERE TABLE1.SOMECOLUMN = (SELECT SOMEOTHERCOLUMN FROM TABLE2 WHERE SOMEOTHERCOLUMN = SOMEVALUE) When I tried this subquery, it doesn't work in SQL-server 2000 at all ! After that I searched online, then found that I have to use "IN" instead of "=" to express the subquery. I am confused ! Why the book writes like that? Is this an old SQL ? SQL is supposed to be universal, why I cannot use above example in SQL2000? I also found some other places which is not wworking in Sql-server 2000 environment. Please help me on this silly question. Thanks Dennis

:confused:hi,dear buddies: I have finished some instroductory books on SQL, but need some practice. Do you guys have any suggestions on where I can find some good exerciese or quizs or real-world cases I can play with? OR any exercises based on the pre-installed database in SQL-server2000 (such as pub,northwind)? Thanks a lot. Waiting online ! Dennis

;PI am planning to take the exams for MCAD, and also bought the training kit. I know the book contains some question examples, but I just wanna know what those exams questions really like: like multiple choice question? like a question/answer? ask you to do a small block of codes? those who have taken this exam, pls give me an idea about this. thanks Dennis

;););););)

:)Hi, Dear all, when I read the codes from other people, a question come up to me: If I know which class/namespace to realize one function, the rest of work is pretty straightforward--just read the documentation and debug, but when I am designing a project and need to add one function to my application, if I had no idea which namespace/class provide this function, how can I find it fast? :confused: For example: when I am doing a graphic application, I wanna add a zoom function to my appli, what is the quickest way to search for right functionality? I tried the MSDN/google, it seems to take long time to find the right thing....:eek: dear bro, I know this may sound like a silly question to you, pls give me some idea what you do when you find yourself in a situation like me? Million Thanks.:rose:

good point, but besides those book examples, how can I get other projects I can pratise on , anything recommend?

thanks for those Key word explanantion, :) yes, i feel quite comfortable with all those keyword and concepts of C#, my feeling is much easier and convenient than MFC(what I used before), and only thing the tutorial didn't cover are IL and reflection, which, I guess, will be covered in "programming C#" by liberty. thanks again:)

Acutally the concepts and basic ideas are not hard to understand, since it is very similar to what I used when I was in school (MFC, C++ etc) My doubt is besides the tutorial, which usually contains only simple examples, what else I can do to get closer to real-world programming? thanks

Thanks Marc: only programing experience I got is from 2year graduate study-- several projects. A couple of questions for you: 1. what is IMO? 2. any good debugger tool you recommended? thanks

more detailed information needed to solve the problems, such as error message, what you did recently, what's the configuration of your pc, have you changed any hardware/software.... then, I may have an idea what's the problem:)

:confused:Graduated as MS in Computer science, I got 2 year IT related experience but not programming, and I am now studying C# for my next job in a consulting company. Below is what I have done and plan to do, I’d really appreciate it if anyone can give me any suggestion or share your experience on learning. Below is my progress & Plan, 1. Already read an online introductory tutorial on basic ideas/tech and run some small codes examples in that tutorial (such as helloworld, creating Modal/Modeless dialog, file/Dir manipulation, simple image process, simple calculator, simple private/shared assembly, simple database application) 2. plan to read "programming C#" by Jesse Liberty and run those examples 3. plan to read and run some examples here in this website 4. plan to readn and run examples in Microsoft.com tutorials Dear buddies, please let me know what you think and what your suggestion. Thanks a loooooooooooooooooooooooot. Dennis

sure, not so effective as in a park, but sometimes esp for me, time and weather are not permitting me to do it in the park, when I come back from office, it is dark..... on those cold wet winter nights, how to do outdoors? .... just a option, not perfect, but better than have no workout, right, pal? ;)

I am a jogging guy, always enjoy myself running on the machine while watching the TV....that's really cool, after 2-3 miles each day for a while, you will find yourself in excellent shape. That kind of machine is really not so expensive nowadays, below 1000.... take care enjoy it !;P

:confused:Anyone who passed the MCAD of microsoft? I am thinking of trying to get that certificate, anyone who has experience on this, please share your experience with me please. such as: 1.what books you used 2.is there any online exams I can take for preparation ... ... Any experience or suggestion will be highly appreciated. ! Dennis

:)depending solely on web MSDN is not enough for me.... anywhere I can download? thanks, all dennis