No Image

PostgreSQL – All about (1)

June 23, 2020 hung-nb 0

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 […]

No Image

SQL: All about image

September 14, 2018 hung-nb 0

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) […]

No Image

MongoDB: All about

February 19, 2018 hung-nb 0

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 […]

No Image

SQL: All about Time

November 2, 2017 hung-nb 0

SQL Server How to add time into a datetime variable? [sql] declare @startDate = ’05 Nov 2017′ SET @startDate = DATEADD(week, 3, @startDate); –’22 Nov […]