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 |
|
hirecrishecom
4 Posts |
 Posted - 2011-12-14 : 05:23:03
|
| Any one know about the Store Procedure then let me Guide...Regards..<removed signature spam> |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-14 : 05:32:04
|
| what do you want to know about store procedures? is it an interview question?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
k_nataraj
Starting Member
7 Posts |
Posted - 2011-12-19 : 05:56:15
|
| A Stored Procedure contains a set of SQL Queries. Say, you would like to create a report and automate it -- you store the sql queries that creates the final report table in Stored Procedure (also called "Proc" or "SP"). You can schedule the SP to run at a particular time and have the data readily available to create a report.SPs are also used in ETL (Extract, Transform, Load process) / data transformations aswell.Hope this helps.regardsNatraj |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-12-21 : 01:38:58
|
| If you have access to SQL Server Books Online - there is a good description.Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-12-21 : 01:43:58
|
see http://bit.ly/tIedGK
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
elmozamil
Starting Member
4 Posts |
Posted - 2011-12-22 : 03:11:03
|
| I will speak about store procedure in another way.Store Procedure provide a good way of security, when you make your logic on store procedure your select statements, insert statements, delete, calculation and so on.a lot of time you hide your business logic in your stored procedure.most important thing store procedure will protect you against SQL Injection (that is very good thing).store procedure help you to protect your table from any insertion by end user, in this case you give your end user permission on execute the stored procedure not on the table.I will post on my blog an in depth topic about SQL Injection, and there also a video.you can visit my blog on: [url]http://http://elmozamil.blogspot.com[/url]There is no thing is impossible if you try harder! |
|
|
|
|
|
|
What is Store Procedure ????