I would like to learn stored procedures but I do not have programming back ground so any one has any suggestion how could I learn sql stored procedure? Please give me some advice.

Vandom
Check this out!

http://databases.about.com/od/sqlserver/l/aastoredprocs.htm

http://www.codetoad.com/asp_sql_stored_procedures.asp

There are number of books of sql stored procedure available in da market.
but only practice can help u out.

Shwetaa

When you say 'stored procedure', I hope you're talking about learning Oracle PL/SQL. Here is a link to a good book:

http://www.course.com/catalog/product.cfm?category=Databases&subcategory=Oracle&isbn=0-619-15959-6

if you want to buy it, get it's ISBN # and buy a used one, which should not cost more than 30 bucks.

If you're a novice programmer, then I suggest you to learn standard SQL that's handled by Oracle. You don't really need any strong programming background to learn SQL. The excercises in this book will teach you all that before you get into PL/SQL and stored procedure.

Your biggest challenge would be to install Oracle software in your computer. You can download it from Oracle website.

Goodluck!

vandam ..if u have read those sites passed to u..and u wanna learn more?or want some books..drop me ur mail...got some ebooks on sql smwhere in some folders..covered with dust..dunno when i be able to dust them off..but yeah if u wanna dust them off..be me guest :oD

and yeah..practice will def help us :oD

good luck(to us and everyone :oD)..and good day!:oD

www.sqlteam.com
www.sqlserverperformance.com
www.microsoft.com/sql
www.umachandar.com