Prev: Connection string to SQL Server to 2005
Next: tsql to change oracle pswd
From: Tony Rogerson on 24 Dec 2009 01:23
> Actually it is DDL, DML, DCL and transaction control. This is one of
> the major problems that cowboy coders have; they think SQL = DML, and
> fail to create integrated systems.
>

You said this...

"BY DEFINITION a column has scalar values, this is not a valid value in SQL"

Holding "1,2,3" in a column has nothing to do with DDL, DML, DCL, {querying}
and transaction control.

IT has everything to do with database design 1nf, 2nf etc...

> LOL! These days, I use a word processor or a spreadsheet most of the
> time! I find that most one-shot jobs

Next time (later this morning) I need to bring in a 20MByte file with a
couple of million rows in it and validate it, and then insert it into my
database I'll be sure to try and do that with Word or Excel.

Right tool for the right job; often SSIS is over kill and takes longer for
what you are trying to do; a lot of the time its easier, more maintainable,
more cost effective to load the data into temporary tables within the
database and use "T-SQL" to validate etc...

But, you'd not know that if you worked just with theory; its only by
actually doing stuff you'd get to know this "experience".


> For repeated jobs, we usually have an ETL tool in my "sheltered
> existence" IT shops.
>

Cool - so, a lot of experience on a day to day basis doing that? Or is it,
as I suspect; something you've only occasionally done
..
Perhaps one of these days I'll bring a lap top with some of the products you
say you have used and put it in front of you and say "go on then, should me
the basics of the product" - I've no doubt in my mind you'd be clueless.

--ROGGIE--

"--CELKO--" <jcelko212(a)earthlink.net> wrote in message
news:01905906-cbad-451f-a5a4-383330258424(a)j24g2000yqa.googlegroups.com...
>>> SQL is querying - nothing more. <<
>
> Actually it is DDL, DML, DCL and transaction control. This is one of
> the major problems that cowboy coders have; they think SQL = DML, and
> fail to create integrated systems.
>
>>> You also show a sheltered existence, really, have you never had to chop
>>> and refine data - would you honestly write a separate one off program in
>>> C when in a fraction of the time you could cut and massage the data into
>>> a structure you want and conforms to proper database design principles?
>>> <<
>
> LOL! These days, I use a word processor or a spreadsheet most of the
> time! I find that most one-shot jobs have the data I want on a
> website for download. Most of the cleanup work is with text --
> squeeze spaces, change case, run a macro and stick it into a CSV file
> for BCP or some INSERT INTO statements.
>
> For repeated jobs, we usually have an ETL tool in my "sheltered
> existence" IT shops.
>
First  |  Prev  | 
Pages: 1 2 3
Prev: Connection string to SQL Server to 2005
Next: tsql to change oracle pswd