Target audience: IT AdministratorsUsed tools: ExcelWhat’s the purpose: quickly to find remote PC for remote support The problem for resolving is : how to manage remote PC with VNC when you have to find definite PC by the post code of the town or village. We can use freeware version of Network Notepad – application… Continue reading How to use Excel to manage remote PC with VNC
Month: January 2014
Read parameters for SQL store procedure from XML variable
Target audience: SQL programmersUsed tools: SQL,XPathWhat’s the purpose: read parameters for SQL query from XML variable Well – the problem is to count all records from a SQL table which satisfy a condition in WHERE clause – like this WHERE table.field > = minVal AND table.field<=maxVal minVal and maxVal are parameters. This is very easy… Continue reading Read parameters for SQL store procedure from XML variable