SQL NewBe wants to learn T-SQL and Stored Proc. 2

[SQLneube]

I want to learn T-SQL and Stored Proc - can you recommend some books that can teach a newbee T-SQL and Stored Proc and Triggers.

Thanks.

 

[SQLDenis]

The Guru's Guide to Transact-SQL

by Ken Henderson

http://www.amazon.com/exec/obidos/t...sql08-20/102-4703055-5891314?v=glance&s=books

Professional SQL Server 2000 Programming

by Robert Vieira

http://www.amazon.com/exec/obidos/t...sql08-20/102-4703055-5891314?v=glance&s=books

Inside Microsoft SQL Server 2000

by Kalen Delaney

http://www.amazon.com/exec/obidos/t...sql08-20/102-4703055-5891314?v=glance&s=books

Microsoft SQL Server 2000 Unleashed (2nd Edition)

by Ray Rankins, Paul Jensen, Paul Bertucci

http://www.amazon.com/exec/obidos/t...sql08-20/102-4703055-5891314?v=glance&s=books

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[SQLBill]

Books OnLine - it's free

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
or online at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/portal_7ap1.asp

-SQLBill

Posting advice: FAQ481-4875

 

[TysonLPrice]

If you don't know SQL at all try here:

http://www.w3schools.com/

Scroll down to Server Scripting and select SQL.

It free and gives you a database and SQL window to play with.