Cannot truncate the table because it is referenced by the FOREIGN KEY constraint?
With MSSQL2005, can I truncate a table with foreign key constraints if I truncate the subtable first (the table with the primary key of the FK relationship)?
I know I can too
Use DELETE without where clause, then RESEED identity (or)
Delete FK, truncate the table, and recreate FK.
I don't think I can use any of the above options ...
Posted by mediabob on Sat, 01 Feb 2020 09:16:02 -0800
Oracle stored PROCEDURE
Stored procedure
A set of SQL statements used to complete specific database functions, which are compiled and stored in the database system. In use, the user calls and executes the stored procedure by specifying the defined stored procedure name and giving the corresponding stored procedure parameters, thus completing one or a series of databas ...
Posted by excessnet on Fri, 31 Jan 2020 01:19:42 -0800
Use of functions, stored procedures, and variables in mysql
1. Variable declaration and assignment
All input and output variables, or variables in use, are either declared with set or declare before they are used
Otherwise, it will result in an undefined variable error.
Univariate assignment
DECLARE @id int(16);
set @a = '12';
set @b = (select count(*) from user);
Multivariate assig ...
Posted by Chicken Little on Sat, 25 Jan 2020 08:15:54 -0800
OA and EHR System Integration Scheme
1. Background introduction
In order to achieve the goal of employee leave, overtime and other personnel process flow and attendance automation, it is necessary to dock the personnel process in OA with EHR system, so that employees only need to fill in application forms, and enter EHR system automatica ...
Posted by heltr on Sun, 19 Jan 2020 17:36:57 -0800
How to import CSV file data into PostgreSQL table?
How to write a stored procedure that imports data from a CSV file and populates tables?
#1 building
You can also use pgAdmin, which provides a GUI to import. Here it is. Show in SO thread . The advantage of using pgAdmin is that it is also applicable to remote databases.
However, much like the previous solution, you will need to have ...
Posted by RoBoTTo on Wed, 08 Jan 2020 03:11:35 -0800
On MySQL transaction and ACID
Recently, I have set up my personal blog. Here is the link: Babble of tobe The article will be updated in blogs and public numbers first.
The so-called Transaction is to maintain the integrity of the database by ensuring that batch operations are either fully executed or not executed at all. Take A rotten Street example: A transfers 1000 yuan t ...
Posted by ddrudik on Tue, 07 Jan 2020 23:12:30 -0800
Oracle functions and stored procedures and packages
Functions are usually instrumental, and stored procedures are usually complex operations of DML
Function has return type return
create function getBookCount return number as
begin
declare book_count number;
begin
select count(*) into book_count from t_book;
return book_count;
end;
end getBookCount;
set serverou ...
Posted by stopblackholes on Sat, 04 Jan 2020 02:01:21 -0800
MySQL basic part: summary of system and custom function, detailed explanation of trigger use
1, System encapsulation function
MySQL has many built-in functions, which can quickly solve some business requirements in development, including process control function, numerical function, string function, date time function, aggregation function, etc. The functions commonly used in these classifications are listed below.
1. Control flow f ...
Posted by netdynamix on Fri, 03 Jan 2020 12:52:53 -0800
Oracle storage functions
Oracle storage functions
The storage function is also a named PLSQL block.
--Note: the stored procedure has no return value, but the stored function has a return value.
The difference between stored procedure and stored function
Generally speaking, the difference between a procedure and a function is that a function can ...
Posted by hongco on Wed, 01 Jan 2020 13:45:28 -0800
Mysql -- stored procedure
A stored Procedure is a set of SQL statements that are compiled and stored in a database to complete a specific function. The user can execute it by specifying the name of the stored Procedure and giving parameters.
Stored procedures can contain logical control statements and data manipulation statements, which can accept para ...
Posted by storyteller on Tue, 31 Dec 2019 03:05:39 -0800