learning stored procedures

[codrutza]

Hi

Does anybody know a way, a good tutorial to learn stored procedures from the very simple ones? Is it a way to try them on my PC? A way to install SQL Server for free for testing?

Thanks

 

[gmmastros]

You can do a google search on "Microsoft SQL Server Express Download". This will bring up microsoft's site where you can download and install the free version of SQL Server. There are limitations with the free version, but it's not anything that would affect your ability to learn about stored procedures.

After installing sql express, check to see if you also have the SQL Server Management Studio. Some of the installers install it and some don't. If you didn't get it with whatever version you downloaded, then do a google search on "Microsoft SQL Server Management Studio Express download" and you'll get to a site that has that available for download.

There are a ton of resources on the internet for learning how to make a stored procedure. For the most part, there is actually very little to learn because they are not very complicated. I would suggest you do another google search on "sql server stored procedure tutorial" and read a few of the articles that it comes up with.

And... of course... if you get stuck on anything, give us a shout.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[codrutza]

Thanks George

 

[chrisdoesstuff]

If you're looking for sample data to go with it you can download adventureworks from Microsoft

http://msftdbprodsamples.codeplex.com/

 

[codrutza]

Thank you ....Chris ?

 

[Wrathchild]

Also there are some templates (not just Stored Procs) available in SQLServer by clicking CTRL + ALT + T - they're pretty raw but you may find them useful

 

[codrutza]

Thank you, Wrathchild