现在查名字是指定了这个名
假如我想查名字为(*明)
请问怎么改,可以实现like'%明'
感谢感谢
declare@Nicknvarchar(100)='小明'
declare@sqlnvarchar(4000)
declare@dbIdxint=1
ifOBJECT_ID('tempdb.dbo.#NickList')isnotnull
droptable#NickList
ifOBJECT_ID('tempdb.dbo.#NickDetail')isnotnull
droptable#NickDetail
createtable#NickList
(
QQNumint,
Nicknvarchar(20),
Ageint,
Genderint,
Authint,
QunNumint,
Titlenvarchar(22),
QunTextnvarchar(80)
)
createtable#NickDetail
(
QunNumint,
Titlenvarchar(22),
QunTextnvarchar(80)
)
while@dbIdx -->
|