Sql server查询问题 [英] Sql server Query Problem

问题描述

嗨。



i有书面查询，可以正常访问。

Hi.

i have written query which works properly in access.

OdbcCommand command = new OdbcCommand("SELECT * FROM [SlideShowTable1] where (startddate <= ?) AND (endddate >=?) ORDER BY rnd (INT(NOW*ImageID)-NOW*ImageID)", con);
            command.Parameters.AddWithValue("sdate", System.DateTime.Now.ToString("M/d/yyyy"));
            command.Parameters.AddWithValue("edate", System.DateTime.Now.ToString("M/d/yyyy"));

但是当我试图在sql server中执行sqme查询时它无法工作..

but when i tried to execute sqme query in sql server then its not working ..

SqlCommand command = new SqlCommand("SELECT * FROM [SlideShowTable1] where (startddate <= @sdate) AND (endddate >=@edate)ORDER BY rnd (INT(NOW*ImageID)-NOW*ImageID)  ", con);
            command.Parameters.AddWithValue("@sdate", System.DateTime.Now.ToString("M/d/yyyy"));
            command.Parameters.AddWithValue("@edate", System.DateTime.Now.ToString("M/d/yyyy"));

推荐答案

首先你应该在Sql server中运行查询，然后加回C＃以执行命令

First You should run query in Sql server and then add back to C# in order to execute command

这篇关于Sql server查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！