Skip to content

Instantly share code, notes, and snippets.

View dami-i's full-sized avatar

Dami Izolan dami-i

View GitHub Profile
@dami-i
dami-i / CPF.java
Last active June 16, 2024 20:28
CPF Value Object
import java.util.stream.IntStream;
public class CPF {
private final String root;
private final String checksum;
private final int regionCode;
private final Region region;
public CPF(String baseValue) {
@dami-i
dami-i / insert_1000_rows_one_transaction.sql
Last active February 4, 2022 15:57
Insert more than 1000 rows on one transaction only (SQL Server - T-SQL)
BEGIN TRANSACTION; -- Whenever possible use transactions when dealing with large amounts of data
INSERT INTO [database].[dbo].[table_name] ([field1], [field2], [field3])
SELECT 'value for row 1 field 1', 'value for row 1 field 2', 'value for row 1 field 3' UNION ALL
SELECT 'value for row 2 field 1', 'value for row 2 field 2', 'value for row 2 field 3' UNION ALL
-- ...N-thousand other rows...
SELECT 'value for row n-1 field 1', 'value for row n-1 field 2', 'value for row n-1 field 3' UNION ALL
SELECT 'value for row n field 1', 'value for row n field 2', 'value for row n field 3'; -- No 'UNION ALL' statement on the last line
COMMIT TRANSACTION;