SQL Server query with batch script

Question

I need to exec this sql query on my Windows SQL Server 2005, can i do this with a batch script?

The sql query

UPDATE VI_CURR_INFO SET 
    ends_days = '2005', 
    check_code = '1', 
    memb_name = '123132', 
    memb_guid = '1', 
    sno__numb = '1', 
    Bill_Section = '6', 
    Bill_Value = '3', 
    Bill_Hour = '6', 
    Surplus_Point = '6', 
    Increase_Days = '0'

The database name is "test1". How to perform a batch script to do that?

Thanks in advance.

user596075 · Accepted Answer · 2012-06-27 02:10:08Z

1

Create a script file that looks like this:

use test1
go

UPDATE VI_CURR_INFO
SET ends_days = '2005', 
    check_code = '1', 
    memb_name = '123132', 
    memb_guid = '1', 
    sno__numb = '1', 
    Bill_Section = '6', 
    Bill_Value = '3', 
    Bill_Hour = '6', 
    Surplus_Point = '6', 
    Increase_Days = '0'

Save this as a script file (Script1.sql for example). And then use SQLCMD to run the script against an instance:

sqlcmd -S YourServerName[\YourInstanceName] -i C:\YourScriptFileDir\Script1.sql

answered Jun 27, 2012 at 2:10

user596075

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server query with batch script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related