Node-Red and MSSQL
Node-Red and MSSQL
Copy JSON
Note: some third-party nodes may appear with blank styling, and not as they appear in the Node-RED Editor.
Copy [{"id":"93fa6dbdaeec3dd2","type":"tab","label":"Flow 1","disabled":false,"info":"","env":[]},{"id":"1bee97cab78f2254","type":"debug","z":"93fa6dbdaeec3dd2","name":"debug 1","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":920,"y":160,"wires":[]},{"id":"752d775a35a124f2","type":"inject","z":"93fa6dbdaeec3dd2","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":160,"y":160,"wires":[["2b9409b17eb0a3fa"]]},{"id":"2b9409b17eb0a3fa","type":"function","z":"93fa6dbdaeec3dd2","name":"Create Table","func":"msg.payload = 'CREATE TABLE iot_info (id INT PRIMARY KEY IDENTITY(1,1), device_name VARCHAR(50), sensor_type VARCHAR(50), sensor_value FLOAT, timestamp DATETIME);'\nreturn msg;","outputs":1,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[],"x":370,"y":160,"wires":[["f714a9850761556e"]]},{"id":"f15d022c745f4874","type":"inject","z":"93fa6dbdaeec3dd2","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":180,"y":260,"wires":[["0f1a11ce964e6cf9"]]},{"id":"0f1a11ce964e6cf9","type":"function","z":"93fa6dbdaeec3dd2","name":"INSERT","func":"msg.payload = \"INSERT INTO iot_info (device_name, sensor_type, sensor_value, timestamp) VALUES ('Device001','Temperature', RAND() * 100, GETDATE());\"\nreturn msg;","outputs":1,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[],"x":400,"y":260,"wires":[["f714a9850761556e"]]},{"id":"262ebd161d630d6f","type":"inject","z":"93fa6dbdaeec3dd2","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":240,"y":340,"wires":[["14deb2f4517dffb0"]]},{"id":"14deb2f4517dffb0","type":"function","z":"93fa6dbdaeec3dd2","name":"SELECT","func":"msg.payload = 'SELECT * FROM iot_info;'\nreturn msg;","outputs":1,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[],"x":500,"y":340,"wires":[["f714a9850761556e"]]},{"id":"f714a9850761556e","type":"MSSQL","z":"93fa6dbdaeec3dd2","mssqlCN":"7bfaa1b5276d6ed6","name":"","query":"","outField":"payload","x":680,"y":160,"wires":[["1bee97cab78f2254"]]},{"id":"7bfaa1b5276d6ed6","type":"MSSQL-CN","name":"","server":"localhost","encyption":true,"database":"iot_info"}]
