Experienced Senior Software Engineer with a demonstrated history of working in the information technology and services industry. Skilled in .Net Software Development, MSSQL, Oracle Database, C#, PHP, Google Cloud Platform and Microsoft Azure. Strong engineering professional with a Bachelor’s Degree focused in Artificial Intelligence from Universiti Teknologi MARA Malaysia. Currently work as Lead Solution Architect and Director of new startup IT company named Aurora Cloud Works Sdn. Bhd.

  • Home
  • /
  • Category Archives: Database

MSSQL Check Compatibility Level

To check compatibility level for your mssql database, you can execute this statement : SELECT compatibility_level , * FROM sys.databases WHERE name = ‘YourDatabaseName’ The number return from the compatibility_level is the version of SQL Server with which the database is to be made compatible. In some cases you can change the value of that…

Submit Data To WebAPI from MSSQL Database

Nowadays, web api is the suitable medium to do integration between system. Here i show one of the way to execute the WebAPI from MSSQL to update send the data. I will use Stored Procedure to implement the execution. Declare @Object as Int; Declare @ResponseText as Varchar(8000); DECLARE @executeApiURL VARCHAR(MAX) SET @executeApiURL = ‘https://tajuzzaman.com/api/Sample.ashx?ApiKey=’ +…