开发者

Visual studio query builder using filter

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开发者_如何学C 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')


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜