Consultas Sql Gestion

dagsis

Bases de Datos

0

Image

Insertar un Lista de Precio a partir de la lista 1

INSERT INTO Precios (lista, producto, porcentaje, precio)
SELECT 
    5 AS lista,           -- nueva lista
    producto,
    porcentaje,
    precio
FROM Precios
WHERE lista = 1;

 

LIMPIAR INSTALACIONES MALAS DE SQL SERVER (Limpiar.bat)

 

@echo off
echo ============================================
echo  LIMPIEZA COMPLETA DE SQL SERVER (TODAS LAS VERSIONES)
echo ============================================
echo Ejecutando como Administrador...
echo.

REM ---- DETENER SERVICIOS SQL ----
echo Deteniendo servicios SQL...
net stop MSSQLSERVER /y >nul 2>&1
net stop SQLSERVERAGENT /y >nul 2>&1
net stop SQLBrowser /y >nul 2>&1
net stop MSSQL$SQLEXPRESS /y >nul 2>&1

echo.

REM ---- DESINSTALAR PRODUCTOS RELACIONADOS (MSIEXEC) ----
echo Eliminando paquetes SQL conocidos...

for %%p in (
  "{F3E6ACF0-7D39-4A57-8E2F-5D3EBA66DFEB}"
  "{BFF2D1A6-77F5-4AD3-9C01-ABC2B8C46E02}"
  "{7F88A253-FR65-4B36-8F97-E5D02F4F2E56}"
  "{1F3E7045-DA5A-4D31-9A0B-033AFD25EC04}"
) do (
  msiexec /x %%p /qb
)

echo.

REM ---- DESINSTALACIÓN MASIVA VIA WMI ----
echo Limpiando SQL, Native Client, OLEDB antiguos...

powershell -Command "Get-WmiObject -Class Win32_Product | Where-Object {
    $_.Name -like '*SQL*' -or
    $_.Name -like '*OLE DB*' -or
    $_.Name -like '*Native*'
} | ForEach-Object {
    Write-Host ('Desinstalando: ' + $_.Name)
    $_.Uninstall() | Out-Null
}"

echo.

REM ---- BORRAR CARPETAS ----
echo Borrando carpetas residuales...

rmdir /s /q "C:\Program Files\Microsoft SQL Server"
rmdir /s /q "C:\Program Files (x86)\Microsoft SQL Server"
rmdir /s /q "C:\ProgramData\Microsoft\SQL Server"
rmdir /s /q "C:\ProgramData\SQL Server"
rmdir /s /q "C:\ProgramData\Package Cache"

echo.

REM ---- BORRAR REGISTRO ----
echo Eliminando claves de registro...

reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server" /f
reg delete "HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server" /f

echo.
echo ============================================
echo     LIMPIEZA COMPLETA FINALIZADA
echo     REINICIA LA PC Y LUEGO INSTALA SQL 2019
echo ============================================
pause

 

0 Comments

Leave a comment

KidKinder

Labore dolor amet ipsum ea, erat sit ipsum duo eos. Volup amet ea dolor et magna dolor, elitr rebum duo est sed diam elitr. Stet elitr stet diam duo eos rebum ipsum diam ipsum elitr.

Get In Touch

Address

123 Street, New York, USA

Email

info@example.com

Phone

+012 345 67890

Newsletter

© Your Site Name. All Rights Reserved. Designed by HTML Codex
Distributed By: ThemeWagon