Learning T- SQL and I need some help

Learning T- SQL and I need some help

Post by Thomas Wimprin » Wed, 04 Jul 2001 03:57:32



I'm currently reading O'Reilly's Transact SQL programming, however I need a
little more than book knowledge and would like some hands on.  Does anyone
have any ideas for a project that I could cut my teeth on?  I can store data
and create tables however it the more complex stuff that I really need to
work with and get the "A ha" moment from.  Any ideas would be appreciated.
Thanks

Thomas Wimprine

 
 
 

Learning T- SQL and I need some help

Post by Itzik Ben-Ga » Wed, 04 Jul 2001 05:04:40


One way to achieve what you want is to try solving questions in this
newsgroup...

:-)
--
BG

Hi-Tech College, Israel
http://sql.hi-tech.co.il


Quote:> I'm currently reading O'Reilly's Transact SQL programming, however I need
a
> little more than book knowledge and would like some hands on.  Does anyone
> have any ideas for a project that I could cut my teeth on?  I can store
data
> and create tables however it the more complex stuff that I really need to
> work with and get the "A ha" moment from.  Any ideas would be appreciated.
> Thanks

> Thomas Wimprine


 
 
 

Learning T- SQL and I need some help

Post by Steve Dassi » Wed, 04 Jul 2001 07:47:31


Check out this Ben-Gan guy on the ng.
He's a real sql mench.You should also check
out the book he co-authored.
Advanced Transact-SQL for SQL Server 2000.

Sql critic

 
 
 

Learning T- SQL and I need some help

Post by Dinesh.T.K » Wed, 04 Jul 2001 08:17:59


Thomas,

okay, if its the T-SQL puzzles you are looking for then you can try with
Joe Celko's Book for the same.Try some samples at

http://www4.nau.edu/its/dba/sql_puzzles.htm (thanks to Priya for the link
:o)

Also try out Guru's guide to T-sql programming by Ken Henderson ...should
give you a headstart.

FYI...creating and storing data may seem easy for you now but in the long
run
its your database design which counts a lot.You can modify the sql query
logic
at any point but to revert back and check the basic design is one hell of a
job!

Dinesh.

 
 
 

Learning T- SQL and I need some help

Post by Steve Dassi » Wed, 04 Jul 2001 08:43:48



.....

I'm thinking of getting a Dinesh doll to use with my voodoo pins.
And if you don't think it works just ask -oj                      :).

VS

 
 
 

Learning T- SQL and I need some help

Post by Dinesh.T.K » Wed, 04 Jul 2001 20:21:28


Quote:> I'm thinking of getting a Dinesh doll to use with my voodoo pins.

would be a bit too xpensive : =)
------
where is oj? :o)

Dinesh.

 
 
 

Learning T- SQL and I need some help

Post by oj » Thu, 05 Jul 2001 02:04:33


hahahahah! he's threatening everyone with voodoo works!  just be careful,
your voodoo dolls might rebel against you. :)

-oj


Quote:> > I'm thinking of getting a Dinesh doll to use with my voodoo pins.

> would be a bit too xpensive : =)
> ------
> where is oj? :o)

> Dinesh.

 
 
 

Learning T- SQL and I need some help

Post by Thomas Wimprin » Thu, 05 Jul 2001 03:35:03


Thanks for the site, thats the thing I was looking for.  As for developing the database I know the planning it important, and is where a lot of mistakes are made I'm sure.  I really want to learn how to do it all properly but I'm sure there is a lot more to that than what I know about.  Thanks for the info...

Can the dolls help rather than hinder?

Tom

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 
 
 

Learning T- SQL and I need some help

Post by Steve Dassi » Thu, 05 Jul 2001 05:34:12



...Can the dolls help rather than hinder?

Ok,you do something kewl and I'll use whipped cream instead
of a
pin.........................................................................
...............:)

stevie

 
 
 

Learning T- SQL and I need some help

Post by Steve Dassi » Thu, 05 Jul 2001 05:40:49



Quote:> hahahahah! he's threatening everyone with voodoo works!  just be careful,
> your voodoo dolls might rebel against you. :)

Just for that I stuck another pin in oj doll!!!!!!!!!!!hehehe
And be careful I may start using bigger pins for bigger.......hehehe
For every sql PITA I can give a real one!!!! :)

Dr. Moreau

 
 
 

1. t- Sql syntax Help Needed!!

Hi
i got a trigger on a table whice i want every time the table will be updated
with a new row
i will be able to change one of her fields the table structure is:

coulmn name |  datatype
----------------------
Date               |  datetime
kerennum      |  numeric
fundnum        |  numerc
include           |  bit

now the goal is to check if the kerennum is a certain number and if the
fundnum is starting with 201 or 404.  (for example 20134242). if it so i
want to set the include value  into 0
he is set to 1 by default.

can't get the RIGHT syntax!!!!!!!1

any sort of help will b arriciated (alot !! my bos is......"a bit"
angry.........)
10x
qlon

2. question about events

3. new to TS and to SQL ...need login help

4. ISO8601 dates in OPENXML

5. Need help learning PL/SQL

6. Repost: Update problems

7. HELP: I need to learn SQL and INGRESS

8. Problem with Informix installation

9. Need Helping in Learning Oracle - check this out !!!

10. Need your help in learning Database Language,

11. Need Friend to Help with Learning Access 97 Database

12. URGENT: Need to move TS from ufs to vxfs file system

13. Urgent need to learn about SQL server