How to execute a .bat without error

Ramon Quintana

7y1.1k

HI, i need to execute this .bat:

echo off

sqlcmd -S MD1Z7UGC\SQLEXPRESS02 -d 1RQ_BPCSQL1 -E -i C:\BPC\Procesos_Almacenados\SQLQuery3.sql

set /p delExit=Presione una tecla para salir...:

but i got this message and nothing happened in sql:

C:\BPC\Procesos_Almacenados>sql.bat

C:\BPC\Procesos_Almacenados>echo off

Changed database context to '1RQ_BPCSQL1'.

Presione una tecla para salir...:

Please any help?

NOTE: due to i installed SSMS for free it doesn't brings the SERVER AGENT allowed, so i have to run SQL files from Windows CDM.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta7y ago
Unfortunately I haven't used too much of sqlcmd utility. You can set the output to a text file and see what's happening. https://docs.microsoft.com/en-us/sql/ssms/scripting/sqlcmd-run-transact-sql-script-files?view=sql-server-2017
Ramon Quintana7y ago
This .Bat calls a Stored Procedure to insert a record with 3 input parameters.
USE [1RQ_BPCSQL1]
GO
----Object: StoredProcedure [dbo].[Proceso_Reporte2] Script Date: 30/05/2019 1:53:05 p. m.
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[Proceso_Reporte2]
@Num_Cta_INI nvarchar(8),
@Num_Cta_FIN nvarchar(8),
@Trans_Type nvarchar(8)
AS
SET NOCOUNT ON;
----insert a record into a table ----------------
insert into dbo.Resultado_Proceso1 (RESULTADO)
select concat (F32,' ',F27,' ',F26,' ',F25,' ',F24,' ',F23,' ',F22,' ',F21,' ',F20,' ',F19,' ',F18,' ',F17,' ',F16,' ',F15,' ',F14,' ',F13,' ',F12,' ',F11,' ',F10,' ',F9,' ',F8,' ',F7,' ',F6,' ',F5,' ',F4,' ',F3,' ',F2) as Result
FROM [1RQ_BPCSQL1].[dbo].[ProcesoReporteKOMBI]
WHERE Trans_Type =@Trans_Type and f33 < @Num_Cta_INI and F34 > @Num_Cta_FIN
executing the SP in sql server it runs perfectly..

but it´s doesn´t matter whats the SP do, so i need to execute any (.SQL) file from Windows to SQL SERVER..due to i dont have the SERVER AGENT actived for schedule JOBS.

;)
Amit Gupta7y ago
If you can share what this command is doing then we can find something like to solution
Ramon Quintana7y ago
Hi Amit, No..the (.bat) file its already created and then i excute it fron CDM:

C:\BPC\Procesos_Almacenados>sql.bat
C:\BPC\Procesos_Almacenados>echo off
Changed database context to '1RQ_BPCSQL1'.
Presione una tecla para salir...:

I try to run the command directly in CDM but nothing happened:

C:\WINDOWS\system32>sqlcmd -S MD1Z7UGC\SQLEXPRESS02 -d 1RQ_BPCSQL1 -E -i C:\BPC\Procesos_Almacenados\SQLQuery3.sql
Changed database context to '1RQ_BPCSQL1'.
C:\WINDOWS\system32>

I got the same Message..
Amit Gupta7y ago
Is this command executed in cmd mannually before converting it to .bat file? If no then do check the proper command line argument and then try