Which is better Stored Procedures or SQL Queries in ASP.Net

Last Reply on Sep 17, 2014 12:29 AM By Mudassar

Posted on Sep 17, 2014 12:29 AM

Using SQL Query as SQL Procedure is better or Using it inside the Coding Section as Simple Query ?

Whose is more better?

Posted on Sep 17, 2014 12:29 AM

Stored Procedures are better.

One reason you can anytime change them without changing code and re-uploading your Website.

Other advantages refer

How to write a stored procedure in SQL Server Management Studio

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html