dos 执行sql并传参

@echo off

@rem set login=wss
@rem set password=123456
@rem set reldb_server="192.168.0.168"


@rem commom parameter
set reportdb="Report_DB_Name"
set contentdb_server="DB_Server"
set contentdb="DB_Name"

@echo on

@rem 0. 清理临时日志文件

del .open.tmp.*.log

@rem 0. 清理function/table/procedure
sqlcmd -U %login% -P %password% -S %reldb_server%  -i C:\Open.tmp\sql\drop_tfp.sql -o .open.tmp.1.drop_tfp.log -v reportdb=%reportdb% contentdb=%contentdb%  contentdb_server=%contentdb_server%

@rem 1. 数据类型创建 [1]

sqlcmd -U %login% -P %password% -S %reldb_server%  -i C:\Open.tmp\sql\dt_tContentTypeId.sql -o .open.tmp.1.dt_tContentTypeId.log -v reportdb=%reportdb% contentdb=%contentdb%  contentdb_server=%contentdb_server%

@rem 2. 表结构创建 [5]

sqlcmd -U %login% -P %password% -S %reldb_server%  -i C:\Open.tmp\sql\t_AllLists.sql -o .open.tmp.2.t_AllLists.log -v reportdb=%reportdb% contentdb=%contentdb%  contentdb_server=%contentdb_server%


@rem 6. 检查参数表数据是否成功插入

sqlcmd -U %login% -P %password% -S %reldb_server%  -i C:\Open.tmp\sql\check_sql_state.sql -o .open.tmp.6.check_sql_state.log -v reportdb=%reportdb% contentdb=%contentdb%  contentdb_server=%contentdb_server%

@rem 7. 合并日志内容，并删除临时日志文件
@rem 为实现按执行先后顺序合并，临时文件名: .open.tmp.sort.procedure_name.sql

copy .open.tmp.*.log sql_task_list.log
del .open.tmp.*.log

pause


@rem sql file get parameters
@rem USE [$(reportdb)]
@rem set @content_db_name = '[$(contentdb_server)].[$(contentdb)].';