blocks|key|1064236|text|我要胡乱猜一猜，但我猜这和你的演员阵容有关。您是否可以将代码更改为：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1064237|object+result+=+cmd.ExecuteScalar();|code-block|syntax|javascript|1064238|并使用调试器检查result变量以查看它是什么(以及它的类型)。这可能会给你(或我)一个关于发生了什么的线索。|offset|length|style|CODE|1064239|entityMap^0|0|0|8|6|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

I'm going to throw out a wild guess, but I'm guessing it has something to do with your cast. Can you change the code to:

<pre><code>object result = cmd.ExecuteScalar();
</code></pre>

And use the debugger to inspect the <code>result</code> variable to see what it is (and what it's type is). This may give you (or me) a clue as to what's going on.

blocks|key|1058380|text|当你说返回的结果是1--它是如何返回的；结果集还是打印输出？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1058381|通常，在使用ExecuteScalar()时，我会使用一个查询来选择单个列值(即格式为SELECT+...出自...)。|1058382|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

When you say the result returned is 1 - how is it returned; resultset or printed out?

Normally when using ExecuteScalar() I use a query which selects a single column value (i.e. of the format SELECT ... FROM ...).

blocks|key|1058388|text|我相信您在C#中的searchBy变量中有一个无关的单引号，请尝试：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1058389|//+note+steve's+rather+than+steve''s,+shouldn't+need+to+escape+the+single+quote
string+searchBy+=
++++"(+FORMSOF+(INFLECTIONAL,+steve's)+AND+FORMSOF+(INFLECTIONAL,+game)+)";
...
cmd.Parameters.AddWithValue("@SearchBy",+searchBy);

int+result+=+(int)cmd.ExecuteScalar();|code-block|syntax|javascript|1058390|1058391|@FlyingStreudel在注释中提出的另一种可能性是，您的存储过程没有使用SELECT返回值。如果你使用的是RETURN，你应该尝试：|1058392|var+retval+=+new+SqlParameter("@RETVAL",+SqlDbType.Int);
retval.Direction+=+ParameterDirection.ReturnValue;
cmd.Parameters.Add(retval);
...
cmd.ExecuteNonQuery();

int+result+=+Convert.ToInt32(retval.Value);|1058393|entityMap^0|9|8|0|0|0|14|6|1L|6|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|U|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|V|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|N|3|O|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|P|3|-4|5|6|7|12|8|@]|D|@]|E|$]]]|Q|$]]

I believe you've got an extraneous single quote in your <code>searchBy</code> variable in the C#, try:

<pre><code>// note steve's rather than steve''s, shouldn't need to escape the single quote
string searchBy =
 "( FORMSOF (INFLECTIONAL, steve's) AND FORMSOF (INFLECTIONAL, game) )";
...
cmd.Parameters.AddWithValue("@SearchBy", searchBy);

int result = (int)cmd.ExecuteScalar();
</code></pre>

<hr>

Another possibility, raised by @FlyingStreudel in a comment, is that your stored procedure is not using <code>SELECT</code> to return the value. If you're using <code>RETURN</code>, you should instead try:

<pre><code>var retval = new SqlParameter("@RETVAL", SqlDbType.Int);
retval.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(retval);
...
cmd.ExecuteNonQuery();

int result = Convert.ToInt32(retval.Value);
</code></pre>

blocks|key|925506|text|ExecuteScalar不是用来执行Stored+Procedures的-为此，你可以结合使用ExecuteNonQuery和Parameters，方向是Output+/+InputOutput+/+Return。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|925507|http://msdn.microsoft.com/en-us/library/system.data.parameterdirection.aspx|925508|http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx|925509|编辑-也许下面的方法也可以(尽管不推荐)：|BOLD|925510|cmd.CommandText+=+"uspMySearch";
cmd.CommmandType+=+Command.StoredProcedure;
cmd.Parameters.AddWithValue("@SearchBy",+searchBy).Direction+=+ParameterDirection.InputOutput;


int+result+=+(int)cmd.ExecuteScalar();

var+Result+=+cmd.Parameters+["@SearchBy"].Value;|code-block|syntax|javascript|925511|entityMap|0|LINK|mutability|MUTABLE|url|1^0|0|D|J|H|1C|F|1S|A|26|6|2F|B|2T|6|0|0|23|0|0|0|25|1|0|0|2|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@$9|10|A|11|B|C]|$9|12|A|13|B|C]|$9|14|A|15|B|C]|$9|16|A|17|B|C]|$9|18|A|19|B|C]|$9|1A|A|1B|B|C]|$9|1C|A|1D|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1E|8|@]|D|@$9|1F|A|1G|1|1H]]|E|$]]|$1|H|3|I|5|6|7|1I|8|@]|D|@$9|1J|A|1K|1|1L]]|E|$]]|$1|J|3|K|5|6|7|1M|8|@$9|1N|A|1O|B|L]]|D|@]|E|$]]|$1|M|3|N|5|O|7|1P|8|@]|D|@]|E|$P|Q]]|$1|R|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]]|S|$T|$5|U|V|W|E|$X|G]]|Y|$5|U|V|W|E|$X|I]]]]

<code>ExecuteScalar</code> is not for executing <code>Stored Procedures</code> - for that you you use <code>ExecuteNonQuery</code> combined with <code>Parameters</code> with direction <code>Output</code> / <code>InputOutput</code> / <code>Return</code>.

<a href="http://msdn.microsoft.com/en-us/library/system.data.parameterdirection.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/system.data.parameterdirection.aspx</a>

<a href="http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.aspx</a>

EDIT - perhaps the following works too (although wouldn't recommend it):

<pre><code>cmd.CommandText = "uspMySearch";
cmd.CommmandType = Command.StoredProcedure;
cmd.Parameters.AddWithValue("@SearchBy", searchBy).Direction = ParameterDirection.InputOutput;


int result = (int)cmd.ExecuteScalar();

var Result = cmd.Parameters ["@SearchBy"].Value;
</code></pre>

I am running into a very interesting bug (or feature).

I have a ADO Command object that makes a call to the database.

The call looks similar to:

<pre><code>cmd.CommandText = "uspMySearch";
cmd.CommmandType = Command.StoredProcedure.
cmd.Parameters.AddWithValue("@SearchBy", searchBy)
// The value of searchBy is: '( FORMSOF (INFLECTIONAL, steve''s) AND FORMSOF (INFLECTIONAL, game) )'

int result = (int)cmd.ExecuteScalar();

// The result returned is 0. I was expecting 1.
</code></pre>

When I execute the same query in SQL/Query Analyzer, I get a different result.

The sql looks like this:

<pre><code>EXEC uspMySearch @SearchBy = '( FORMSOF (INFLECTIONAL, steve''s) AND FORMSOF (INFLECTIONAL, game) )'

// The result returned is 1. This is the expected result.
</code></pre>

In order to confirm I was calling the correct stored procedure, I modifed uspMySearch to return a random number. I was calling the right Sp!

Anyone have any insights as to whats going on here?

Thanks.

Steve

Environment

SQL/Server 2008 R2

.NET 4.0

ExecuteScalar returns different result than Pure SQL

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我遇到了一个非常有趣的bug (或特性)。我有一个调用数据库的ADO Command对象。调用类似于：cmd.CommandText = "uspMySearch";cmd.CommmandType = Command.StoredProcedure.cmd.Parameters.AddWithValue("@Sear...

问ExecuteScalar返回的结果与纯SQL不同
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ExecuteScalar返回的结果与纯SQL不同EN