Hello, Can anyone have used Mssql Stored Procedures.. what is it, waht are it's advantages.. etc... Thanks in advance!!
stored procedures are t-sql statements that are stored at the server. these can be as simple as a select statement or very complex statements that uses multiple joins and regular expressions. mssql stores these procedures in a manner that is very efficient and can provide much much better performance as compared to being called via a client.