大佬们,我的公式如下,需要获取Q3单元格值并转换bigint。但是公式没通过,转换那里该怎么改?
select cst.salesIssue_id from dbo.csTable cst join dbo.checkAndAccept caa on caa.id = cst.checkAndAccept_id where cst.checkAndAccept_id = convert(bigint,'"+Q3+"')
select cst.salesIssue_id from dbo.csTable cst join dbo.checkAndAccept caa on caa.id = cst.checkAndAccept_id where cst.checkAndAccept_id = convert(bigint,'${Q3}')
单元格*1就转成int了