How to pass parameter from sql to batch file

Question

How to pass parameter from sql to batch file  and how to send mail through .bat(batch) file.

Gareth Bradley · Answer

What is the reason on wanting to use a Batch File? If turned on you can use Database Mail and there is a nice proc within SQL Server itself called sp_send_dbmail  that way you dont need to worry about dropping data from sql. https://msdn.microsoft.com/en-us/library/ms190307.aspx

Tejas Trivedi · Answer

Hi Saravana You can pass parameter using sqlcmd command. For sending an email from the bat file either you need to write powershell script or VBScript and then call it from the batch script. Hope this will give you high level idea to resolve your issue. Please feel free to write if more information is required. Please don't forget to mark as answer if this helps.