DSCResources/common/windows.SqlScriptQuery.ps1

#region Header
$rules = Get-RuleClassData -StigData $StigData -Name SqlScriptQueryRule
#endregion Header
#region Resource
foreach ($instance in $ServerInstance)
{
    if ($null -ne $Database)
    {
        foreach ($db in $Database)
        {
            foreach ( $rule in $rules )
            {
                SqlScriptQuery "$(Get-ResourceTitle -Rule $rule)$instance"
                {
                    ServerInstance = $Instance
                    GetQuery       = $rule.GetScript
                    TestQuery      = $rule.TestScript
                    SetQuery       = $rule.SetScript 
                    Variable       = $db
                }
            }
        }
    }
    else 
    {
        foreach ($rule in $rules)
        {
            SqlScriptQuery "$(Get-ResourceTitle -Rule $rule)$instance"
            {
                ServerInstance = $instance
                GetQuery       = $rule.GetScript
                TestQuery      = $rule.TestScript
                SetQuery       = $rule.SetScript 
            }
        }
    }
}
#endregion Resource