如果我手动读取Inv路径，如何获取文件计数 [英] How Can I Get The Files Count If I Read The Inv Path Manually

问题描述

select * from files where invID=(select invID from tblInventory where invFolderPath="@invFolderPath")

或

or

select * from files where invID=(select invID from tblInventory where invFolderPath="C:\")

i我收到的错误如无效的coloumn名称c：\



i我给出了硬编码路径，但我想动态地获取它...

任何人都可以lp me

i am getting the error like Invalid coloumn name "c:\"

i am giving the hard coded path but i want to get it dynamically..
could anyone help me

推荐答案

SQL - 默认情况下 - 不理解双引号，因此C：\被解释为对象/列名...

识别字符串文字的正确方法是使用SINGLE引号，例如'C：\'...

SQL - by default - do not understand double quotes, so "C:\" is interpreted as object/column name...
The proper way to identify string literals is using SINGLE quotes, like 'C:\'...

这篇关于如果我手动读取Inv路径，如何获取文件计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！