TAJUZZAMAN

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
  • /
  • Tag Archives:  MSSQL

SQL, list all column in table

To write the INSERT statement that required you to write all the field is stress work for developer.. Here is the SQL command to return all column from a table that we can direct copy and past into our insert statement. SELECT column_name + ‘,’ FROM information_schema.columns WHERE table_name = ‘users’ =)

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=’ +…