tag:blogger.com,1999:blog-6082652835152798567.post1275487792066937258..comments2024-03-28T21:41:58.974-07:00Comments on Sql server, .net and c# video tutorial: Advantages of using stored procedures - Part 21Unknownnoreply@blogger.comBlogger6125tag:blogger.com,1999:blog-6082652835152798567.post-61447073175925428392016-07-27T23:30:48.943-07:002016-07-27T23:30:48.943-07:00Since u r not altering the stored procedure.. the ...Since u r not altering the stored procedure.. the Execution plan may be reused again.. Correct me if i am wrongRajendra Prasad C Shttps://www.blogger.com/profile/17875055263930674992noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-80715318019706979812016-07-08T08:11:56.347-07:002016-07-08T08:11:56.347-07:00Changes made to a single procedure, which would dr...Changes made to a single procedure, which would drop all plans for that procedure from the cache (ALTER PROCEDURE).<br />Anonymoushttps://www.blogger.com/profile/06321465681611065725noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-44070079028671840792015-09-20T04:54:07.193-07:002015-09-20T04:54:07.193-07:00venkat your videos are awesome to learn but i feel...venkat your videos are awesome to learn but i feel it would have been more useful if you give a exercise after every tutorials you perform. Anirbannoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-55984356109652190082015-07-23T11:31:38.190-07:002015-07-23T11:31:38.190-07:00I have one question regarding Execution plan reten...I have one question regarding Execution plan retention and reusability, if there is a "Select * from table" statement in the Stored procedure. Execution plan is cached and used again? What if a new column is added in the table, Execution plan will change or use the cached one?<br /><br />- AjitAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-28247404306317987762015-02-04T06:56:20.305-08:002015-02-04T06:56:20.305-08:00Hello There!
I think you should refer SQL injecti...Hello There!<br /><br />I think you should refer SQL injection topic. Because if you use inline queries in the application and suppose taking values from textbox, then user may use injection techniques to fetch data through provided input control. However SPs provide more secured way extracting data. point 4 &5 are in relation to each other.<br /><br />-PankajAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-27110034414677884602015-01-26T06:53:13.381-08:002015-01-26T06:53:13.381-08:00Sir, can you explain 4.Better Security Point in de...Sir, can you explain 4.Better Security Point in detail. Such as how to give grain access control Anonymousnoreply@blogger.com