C# 如何在sql中将位数据类型转换为varchar

Question

提问by user2327795

How to convert BIT datatype to Varchar in sql ?

如何在 sql 中将 BIT 数据类型转换为 Varchar？

I tried CAST

我试过 CAST

CAST(IsDeleted as Varchar(512))

But it didn't work....

但它没有用......

Note: IsDeletedis a BIT datatype and I need to convert it into Varchar or Int

注意：IsDeleted是 BIT 数据类型，我需要将其转换为 Varchar 或 Int

Answer 1

Assuming this is MySQL, you can't cast to VARCHAR. The allowable types are shown here; they're listed after the CONVERTfunction explanation.

假设这是 MySQL，您不能强制转换为VARCHAR. 此处显示了允许的类型；它们列在CONVERT功能说明之后。

You can cast to CHAR(1)though. For example:

你可以投射到CHAR(1)。例如：

CAST(b'11' AS CHAR(1))

Answer 2

CAST(IsDeleted AS INT) AS IsDeleted

This should work I just tried it in SSMS and it works like a charm

这应该可以工作，我刚刚在 SSMS 中尝试过，它的作用就像一个魅力

Answer 3

SELECT
    CASE WHEN IsDeleted = 1 THEN 'True' ELSE 'False' END AS IsDel
FROM
    Table

Answer 4

is the attribute nullable?

是属性nullable？

Try

尝试

CONVERT(varchar, ISNULL(isDeleted,0))