sql server存储过程语法及vb调用存储过程存储过程（SQL server stored procedure syntax and VB call stored procedure stored procedures）.docVIP

sql server存储过程语法及vb调用存储过程存储过程（SQL server stored procedure syntax and VB call stored procedure stored procedures） The SQL server stored procedure syntax and the VB call stored procedure stored procedures are one or more SQL commands stored in the database as executable objects. Definitions are always abstract. Stored procedures are actually a set of SQL statements that can perform certain operations, except that the set of statements is placed in the database (here we only talk about SQL Server). If we create stored procedures and call stored procedures in ASP, we can avoid mixing SQL statements with ASP code. There are at least three advantages to doing so: First, greatly improve efficiency. The stored procedure itself performs very quickly, and calling stored procedures can greatly reduce the number of times a database interacts. Second, improve safety. If the SQL statement is mixed in the ASP code, once the code has been compromised, but also means that the database structure is compromised. Third, it facilitates the reuse of SQL statements. In VB, call stored procedures are generally invoked through command, Connection objects, or Recordset objects, and other invocation methods are introduced, depending on the situation. For illustrative purposes, the following simple classification is based on the input and output of stored procedures: 1. stored procedures that return a single Recordset Assuming the following stored procedures (the purpose of this article is not to tell the T-SQL syntax, the stored procedure only gives the code and does not explain it): /*SP1*/ CREATE PROCEDURE getUserList As Set NOCOUNT on Begin Select * from userinfoend Go The above stored procedure takes all the records in the userinfo table and returns a recordset. The ASP code that calls the stored procedure through the command object is as follows: * * * * through the Command object stored procedure call DIM, MyComm, MyRst Set MyComm = Server.CreateObject (ADODB.Command) MyComm.ActiveConne