使用过滤器的 Visual Studio 查询生成器
您好，我已经进行了查询，但没有给出任何结果，我使用 3 个参数 cri、d1 和 d2 我想在运行时给出值，但是当执行此查询时，即使我给出了正确的输入，也不会显示任何数据
SELECT [Name Of District],
[ANC Id],
[Gram Panchayat or Village],
[Name Of Subcenter],
[Name Of PHC],
[Name Of Cluster],
[ANC Name],
EDD,
[2nd ANC],
[3rd ANC],
[4th ANC],
[TT Bosters]
FROM [ANC Data]
WHERE ('@ cri' BETWEEN '@ d1' AND '@ d2')
hi i have made a query but it is not giving any results, i am using 3 parameters cri,d1 and d2
i want to give values at run time, but when this query is executed no data is displayed even though i am giving correct input
SELECT [Name Of District],
[ANC Id],
[Gram Panchayat or Village],
[Name Of Subcenter],
[Name Of PHC],
[Name Of Cluster],
[ANC Name],
EDD,
[2nd ANC],
[3rd ANC],
[4th ANC],
[TT Bosters]
FROM [ANC Data]
WHERE ('@ cri' BETWEEN '@ d1' AND '@ d2')
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可以尝试使用SQL Server Profiler工具来检查真正的SELECT具有实际 WHERE 参数值的语句。
只需在 SQL Server Management Studio 环境中执行相同的 SELECT 语句并检查是否有满足SELECT查询的数据记录。
You can try to use the SQL Server Profiler tool to inspect the real SELECT statement with real WHERE parameters’ values.
Just execute the same SELECT statement within the SQL Server Management Studio environment and check whether there is any data records satisfied to the SELECT query.