Advantages of using stored procedures:
1.Stored procedures are pre-compiled in the database,Compared with pure SQLHigher execution efficiency
2.The amount of data transmitted by stored procedures over the network is more than that transmitted by pure SQL statements.Few statements.
3.Stored Procedures hide Data Execution details,Make data more secure
The basic operations of the database are divided into addition,Delete,Change,QueryFour types,Add, delete, modify, and operate data,Is directly affecting data,After the operation,The number of affected rows is returned,But different queries,Check does not affect the data itself,Only a result set is returned and displayed to the user,Therefore, you can divide addition, deletion, and modification into one type,QueryIs a class.In ADO. NETSQLThe method is also different ..
Please read the attachment document directly...