DosTips.com

I have few queries writtern in different rows in excel like In Sheet1 cell A1 - SELECT FROM DBO.EMP cell A2 - select from dbo.dept cell A3 - select from dbo.emp except select from sa.emp cell A4 - select * from sa.loc now I want these queries to be fired in some test db in sql server 2017, and the o...

I am trying to create windows batch script to check the size of file after it is downloaded but it fails with this message. The Process cannot access the file as it is used by another process 2048 was unexpected at this time. Thanks in advance for any help. Code - @echo off d:\wget.exe ... Rem this ...

Am trying to loop through the below code until the count returns value greater than 0 (Each iteration should get paused for 5 minutes). Once count returns value greater than 0 it has to exit the indefinite loop and fire insert query to specific table. Am connecting to sql server DB for /f %%a in ('s...