Month: August 2017

No Image

Menus

August 4, 2017 hung-nb 0

Fixed menu in every page Show a menu at mouse cursor when left/ right click

No Image

Cron jobs

August 2, 2017 hung-nb 0

How to find jobs calling a certain stored procedure? SQL Server [sql] DECLARE @Search varchar(255) SET @Search=’keyword’ SELECT j.name as job_name, s.step_id, s.step_name FROM msdb.dbo.sysjobsteps […]

No Image

Send Mail: All about

August 2, 2017 hung-nb 0

Windows Server Develop a Windows Service on SQL Server This service will check the MAIL_QUEUE table every a certain of time to send emails Mail […]

No Image

Read/ Write File/Folder

August 2, 2017 hung-nb 0

Read a file Node JS Buffering Contents with fs.readFile [js] // synchronously var fs = require(‘fs’); try { var data = fs.readFileSync(‘my-file.txt’, ‘utf8’); console.log(data); } […]

No Image

Questions

August 1, 2017 hung-nb 0

What is the difference between TRUNCATE and DELETE? Which TRUNCATE or DELETE is better? How to record actions happening on Stored Procedures? How to record […]