Execute An Sql Query In Microsoft Sql

About This Script

Features:

• Automates workflow tasks
• Ready to import into n8n
• Configurable parameters

{
    "nodes": [
        {
            "name": "On clicking 'execute'",
            "type": "n8n-nodes-base.manualTrigger",
            "position": [
                250,
                300
            ],
            "parameters": [],
            "typeVersion": 1,
            "id": "5e2ac1e8-adf4-4ba4-8de2-47300e05f0a0"
        },
        {
            "name": "Microsoft SQL",
            "type": "n8n-nodes-base.microsoftSql",
            "position": [
                450,
                300
            ],
            "parameters": {
                "query": "",
                "operation": "executeQuery"
            },
            "credentials": {
                "microsoftSql": ""
            },
            "typeVersion": 1,
            "id": "5cae2a9c-5217-4a25-b3c5-d01a918c592d"
        }
    ],
    "connections": {
        "On clicking 'execute'": {
            "main": [
                [
                    {
                        "node": "Microsoft SQL",
                        "type": "main",
                        "index": 0
                    }
                ]
            ]
        }
    },
    "n8n_version": "1.5.0"
}

Requirements