Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2006-08-29 : 07:33:50
|
| Dear Experts,I'm working for aproduct based company, i need guidence from you in some respects1) how to become expertise in functions and stored procedures?is there any good links for me, i'm a learner.of cource google is there, but i dont know the starting point.please provide me some good links, and your esteemed guidence |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-29 : 07:37:29
|
| Bol (books online) is the best place to start.Try and post questions on forums.There are some books recommended on this site too.Probably take about 2 years to become fairly proficient.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-29 : 07:56:04
|
| here are some good books to get http://www.sqlteam.com/store.aspthe Ken Henderson books are especially good, although they might be a little advanced for someone new to TSQL.-ec |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-08-29 : 09:28:23
|
| I vote for a good book. sit down, get confortable, read about it. BOL ("Books on-line", the SQL server help file) is a great reference, but not the best starting point.- Jeff |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-01 : 16:49:16
|
Great question sunsanvin ...... its the Holy Grail isn't it? I've been doing this 20 years; I'm still learning tricks, but basically folk around me are pleased, and sometime surprised, at the solutions I come up with. To them it appears that it needs no thought on my part to come up with a solution which is significantly better than what they have thought of.In reality that's what we call "Experience". How wonderful would it be, by any Metric you care to use, that all of us could use the optimal, bast-of-breed-based-on-experience-solution, in all instances, and with, preferably, only 10-minutes instruction?  To date you either need a) incredible aptitude or b) years of experience.I'd love to find a quicker way of accelerating the learning, but sadly I don't know how it achieve that; sorry!Kristen |
|
|
|
magnetica
Starting Member
36 Posts |
Posted - 2006-09-01 : 20:27:57
|
| [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210[/url]Sticky topics are always handy! But yes books are the way forward, get a SQL Server book either E_book or not, either way?!If you think you know it all?! You know nothing! |
|
|
|
|
|
|
|
|
procdures and functions