MSQL

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

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

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] ALTER TABLE TestTable ADD DateInserted DATETIME NOT NULL DEFAULT (GETDATE()); [/sql]

CROSS APPLY can do with Some conditions that INNER JOIN can’t easily do CROSS APPLY is quicker than INNER JOIN

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

A query with SELECT DISTINCT can be rewritten using GROUP BY. So this [sql] SELECT DISTINCT city FROM HR.Employees WHERE country = N’USA’ AND region […]

Convert varchar to decimal error 1 Add another column with required dataType. [sql] ALTER TABLE [table name] ADD [column name] decimal(10,2) NULL [/sql] Import all […]