[文本处理] [已解决]批处理进行SQL模糊查询字符串时的变量要怎么定义？

lovealei

OSQL -S sqlserver -U user -P sqlpwd  -d local -Q "Select level,Balance from member where (userid like %'08113817'%)
复制代码

上面代码中的 08113817 是一个变量,是让用户输入的,这里如果用变量名就会查询不到

OSQL -S sqlserver -U user -P sqlpwd  -d local -Q "Select level,Balance from member where (userid like %'%ID%'%)
复制代码

要怎么修改下呢??

有4个%

lovealei

回复 3# powerbat


        谢谢哥们,解决了

lovealei

awk 发表于 2011-11-20 19:05

    谢谢哥们

powerbat

批处理中一个%符号本身要用两个表示，写成%%

@echo off
set /p ID=请输入：
OSQL -S sqlserver -U user -P sqlpwd  -d local -Q "Select level,Balance from member where (userid like '%%%ID%%%')

awk

@echo off
setlocal enabledelayedexpansion
set /p ID=请输入：
OSQL -S sqlserver -U user -P sqlpwd  -d local -Q "Select level,Balance from member where (userid like %'!ID!'%)
复制代码