|
|
Posted by Erland Sommarskog on 08/16/06 15:32
(dba_222@yahoo.com) writes:
> Sorry if I'm rubbing anyone the wrong way. But I'm sure you tell, I
> was getting really pissed off here. I've been working in tech for a
> long time. I know that in the beginning, you have to get the basics
> down. Syntax. Variables. Built in functions and other features.
> Libraries. How to compile and link. How it's done in this language.
> Etc. I've done this with Oracle, C, VB, some java and so on.
If you want to learn basic, why start with cursors? Cursors are not
basics, cursors are things you use very occcasionally, the less the
better. Not that I know Oracle, but I can't imagine that this any different
in Oracle or any other DBMS.
If you want to learn basics for SQL, start with learning queries first.
Then how to create tables and indexing. Then you can look at flow-of-
control, procedures etc. Cursors you can save until you need them. And
if you learn the basics well, you may not even need them.
> Just how do I do it please? Not an intellectual discussion.
> Not questions or comments about what I'm trying to do.
> Consider it a test question where only the right answer gets
> you the marks.
I will have to confess that my interest in getting marks for newsgroups
posts is minimal.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|