从SQL存储过程返回BIT常量

问题描述

确定，我要从存储过程返回BIT常量。

我设法得到这个编译的唯一方法是使用转换：

CAST（0 AS BIT）AS MyBool

有没有更高效的方式来写这个没有转换？

解决方案

有些人喜欢做以下事情：

  declare @True bit，@ False bit 
 set @True = 1 
 set @False = 0 
  

然后在查询的剩余部分使用 @True 或 @False p>

我想象，后编译两种方法之间的效率差异是如此微小，你可以安全地写在任何你喜欢的风格。

OK, I'm trying to return a BIT constant from a Stored Procedure.

The only way I've managed to get this to compile is using a cast:

CAST(0 AS BIT) AS MyBool

Is there a more efficient way to write this without a cast?

解决方案

Some people prefer to do the following

declare @True bit,@False bit
set @True = 1
set @False = 0

And then use @True or @False for the remainder of their query.

I would imagine that post compilation the difference in efficiency between the two methods is so vanishingly small you can safely write it in whatever style you prefer.

这篇关于从SQL存储过程返回BIT常量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！