Tag：stored procedure
-
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, […]
-
Time：2020-10-29
SQL Server batch export stored procedures In the query analyzer, select database, right-click task, and select generate script from the pop-up menu ——》”Next step” — “select the database where you want to store the procedure” “Next step” — check “stored procedure” and “next step” Check the name of the stored procedure you want to generate, […]
-
Time：2020-10-28
IF EXISTS (SELECT name FROM sysobjects WHERE name = N’cg_DoBackupJob’ AND type = ‘P’) DROP PROCEDURE cg_DoBackupJob GO CREATE PROCEDURE [cg_DoBackupJob] @DataBaseName varchar(100), @FileHead varchar(50), @Isfullbackup bit, – 0 differential backup 1 full backup @FolderPath varchar(50) = ‘f:\db_backup\’, @Backname varchar (100) =’unknown ‘, — description string @Isappendmedia bit = 1 — 0overlay media 1 append […]
-
Time：2020-10-27
This paper describes the Oracle stored procedure cursor usage. For your reference, the details are as follows: Five steps to use a cursor 1. Declare variables to hold the index returned by the select statement2. Declare the cursor and specify the select statement3. Open cursor4. Get record from cursor5. Close cursor Get each record from […]
-
Time：2020-10-26
This paper describes the Oracle stored procedure loop syntax. For your reference, the details are as follows: 1. Simple cycle grammar loop statements; end loop; example: counter := 0; loop counter := counter + 1; exit when counter = 5; end loop; Note: the exit statement immediately ends the loop, and the exit when statement […]
-
Time：2020-8-20
Create a process on your hard disk test.sql create or replace procedure test_bf is begin dbms_output.put_line(‘test success’); end; Then the procedure is encrypted by using Oracle’s own wrap command First open the CMD and then enter the command wrap iname=’input_name’ oname=’output-name’ input_ Name is the path of the file to be encrypted, output_ Name is […]
-
Time：2020-8-16
This paper describes the Oracle stored procedures, functions and triggers. For your reference, the details are as follows: 1、 Stored procedures and stored functions It refers to the subroutines stored in the database for all user programs to call, called stored procedures and stored functions. Create stored procedure Use the create procedure command to create […]
