React Native – How to setup push notification with Firebase (4)?
How to create DB for sending notification to a specific device? How to create related APIs? API of getting user id, fcmToken 2 APIs of […]
Database
PostgreSQL – How to use “upsert”?
If data exists, do nothing (don’t INSERT) If name column has same data, do nothing If data exists, UPDATE row Before After
PostgreSQL – All about (1)
What is difference between Postgres and PgAdmin Postgres.app is a full-featured PostgreSQL installation packaged as a standard Mac app. It sets up a PostgreSQL database server […]
SQL: All about image
How to insert image file as blob data (varbinary(max)) MS SQL [sql]insert TEMP_UPLOAD_IMAGE (UploadInspectionId, FileName, Data) values (1002666, ‘IMG_20180823_061350847.jpg’, (SELECT BulkColumn FROM OPENROWSET(BULK N’D:\_temp_\IMG_20180823_061350847.jpg’, SINGLE_BLOB) […]
MongoDB: All about
Installation Install “msi” file from official site Create batch file to run every time [js]C:\mongodb\bin\mongod.exe –dbpath “C:\Users\abc\Desktop\[database folder path]”[/js] Practical usage INSERT [js] let data […]
SQL Error handling: All about
SQL Server How to apply “try/catch” in query? SQL Server[sql]Begin try BEGIN TRANSACTION; DELETE___ WHERE___ End try Begin catch if @@error <> 0 goto err […]
SQL Server: Math expression
power The result is the same data type as the specified numeric expression. Therefore, if the result has three decimal places, the number to raise […]
SQL Server: How to add column with default current time updated in every INSERT/ UPDATE record
[sql] ALTER TABLE TestTable ADD DateInserted DATETIME NOT NULL DEFAULT (GETDATE()); [/sql]
SQL Server: “CROSS APPLY” vs “INNER JOIN”
CROSS APPLY can do with Some conditions that INNER JOIN can’t easily do CROSS APPLY is quicker than INNER JOIN
SQL: All about Time
SQL Server How to add time into a datetime variable? [sql] declare @startDate = ’05 Nov 2017′ SET @startDate = DATEADD(week, 3, @startDate); –’22 Nov […]