Tag：stored procedure
-
Time：2021-7-7
Let’s start with a concept Database transaction refers to a series of operations executed as a single logical unit of work, either executed completely or not. Then, adding a transaction to a stored procedure can ensure that all SQL codes in the transaction are either executed completely or not executed at all. For example, a […]
-
Time：2021-7-2
In the project, a large amount of data information is often saved to the database. If only one table is used to save the data, it is certainly not realistic. The preferred solution is to establish a dynamic table by date to save the data. Without changing the code of saving method, dynamic stored procedure […]
-
Time：2021-7-1
realization 1) If you have the same data, you can return it directly (return value: 0); 2) Update the data with the same primary key but different data (return value: 2); 3) No data, insert data processing (return value: 1). Create stored procedure Create proc Insert_Update @Id varchar(20), @Name varchar(20), @Telephone varchar(20), @Address varchar(20), @Job […]
-
Time：2021-6-18
1、 Custom function: 1. Table variables can be returned2. There are many restrictions, includingThe output parameter cannot be used;Temporary tables cannot be used;The operation inside the function cannot affect the external environment;The result set cannot be returned by select;Cannot update, delete, database table;3. Must return a scalar value or table variableUser defined functions are generally […]
-
Time：2021-6-16
MySQL version 5.0 started to support stored procedures. Stored procedure is a kind of database object which is stored in database for external application to call. Stored procedure is a set of SQL statements to complete specific functions. It is compiled, created and saved in the database. Users can call and execute it by specifying […]
-
Time：2021-5-3
This paper introduces the concept, principle and common usage of MySQL stored procedure. The details are as follows: 1. The concept of stored procedure In some languages, such as Pascal, there is a concept called “procedure” and “function”. In PHP, there is no procedure, only function. Procedure: encapsulates several statements, which are executed when calledFunction: […]
-
Time：2021-4-17
The stored procedure in transact SQL is very similar to the method in Java language. It can be called repeatedly. When a stored procedure is executed once, the statement can be cached, so that the next time the stored procedure is executed, the statement in the cache can be used directly. This can improve the […]
-
Time：2021-4-14
Recursion refers to the situation in which a code fragment calls itself; the danger lies in how to prevent it from calling itself repeatedly if it calls itself once. That is to say, recursion test is provided to ensure that it can jump out at the right time. Take hierarchy as an example to explain […]
-
Time：2021-4-13
Before 2008, if we want to pass the table as an input parameter to the SQL server stored procedure, it will be more difficult. We may need a lot of logic processing to pass the table data as string or XML. Table valued parameters are provided in 2008. Using table valued parameters, you can send […]
-
Time：2021-3-31
The following trigger is used to monitor changes to stored procedures. To create a monitoring table: CREATE TABLE AuditStoredProcedures( DatabaseName sysname , ObjectName sysname , LoginName sysname , ChangeDate datetime , EventType sysname , EventDataXml xml ); Create monitoring trigger: CREATE TRIGGER dbtAuditStoredProcedures ON DATABASE FOR CREATE_PROCEDURE, ALTER_PROCEDURE, DROP_PROCEDURE AS DECLARE @eventdata XML; SET […]
-
Time：2021-3-10
SQL paging stored procedure code, need friends directly to use, use is very simple. The sharing code is as follows USE [SendMessage] GO /****** Object: StoredProcedure [dbo].[pages] Script Date: 07/09/2015 13:46:50 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROC [dbo].[pages] ( @TBNAME nvarchar (100), — the name of the table to be […]
-
Time：2021-1-14
MySQL stored procedure 1. Create stored procedure syntax (format) DELIMITER $ Create procedure stored procedure name a (in passes in parameter name a int, in passes in parameter name B varchar (20), out returns parameter name C int) BEGIN Content END $ Analysis: In represents the incoming parameter, defines the name of the incoming parameter, […]
