Newbie

Question

Post reply

Newbie

Arunkumar-278963

Newbie

Points: 2
More actions
November 18, 2005 at 12:02 pm

#90829

Hello, I am new to TSQL. Can some one suggest a Beginners Book to understand Stored Procedure.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

Why only stored procedures ?!?!

I've always found the wrox publications great reads..

1)"SQL Server 2000 Programming" - Beginning - Robin Dewson

1)"SQL Server 2000 Programming" - Professional - Robert Vieira

**ASCII stupid question, get a stupid ANSI !!!**

Arunkumar-278963 Newbie Points: 2 More actions · Answer 2

Thank you,Sushila. I need a begginners book to understand how the stored procedures work because all my table updates in my new job is through stored procedure. I am new to Programming.

SQLBill SSC Guru Points: 51440 More actions · Answer 3

Start with the BOL...it's free and it's the Official SQL Server Help file...

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

sushila SSC-Dedicated Points: 35293 More actions · Answer 4

I just found this t-sql programming book on the Net, but in the reviews one of them says that it's just a poor second to "BOL"...so guess that as SQLBill suggests - that'd really be your best bet!

**ASCII stupid question, get a stupid ANSI !!!**

Jeff Moden SSC Guru Points: 1004648 More actions · Answer 5

Take a look at the SQL portion of w3schools.com. It won't teach you all of the nuances of MS-SQL Server but it will give you a nice comfortable start on the basics of SQL in general. It even let's you try code out... it's in a very tutorial fashion that's easy to use, as well.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

sushila SSC-Dedicated Points: 35293 More actions · Answer 6

& here's the w3 link in case you don't have it!

**ASCII stupid question, get a stupid ANSI !!!**