select @sTableName='tInOrder'
select @dBillDate='20040704'exec('select count(*) from '+@sTableName+' where BillNo in
select BillNo from '+@sTableName+' where left(BillNo,8)='+@sBiLLNo)
请问这个嵌套查询哪里错了,应该如何写?
select @dBillDate='20040704'exec('select count(*) from '+@sTableName+' where BillNo in
select BillNo from '+@sTableName+' where left(BillNo,8)='+@sBiLLNo)
请问这个嵌套查询哪里错了,应该如何写?
(select BillNo from '+@sTableName+' where left(BillNo,8)='+@sBiLLNo+')')select ... from .. where in (....) 你是不是少了in后面的()