t sql 中是否有 StartsWith 或 Contains 变量? [英] Is there StartsWith or Contains in t sql with variables?

问题描述

我正在尝试检测服务器是否正在运行 Express Edition.

I am trying to detect if the server is running Express Edition.

我有以下 t sql.

I have the following t sql.

DECLARE @edition varchar(50); 
set @edition = cast((select SERVERPROPERTY ('edition')) as varchar)

print @edition

在我的例子中，@edition = Express Edition(64 位)

我该怎么做?(受 C# 启发).

How can I do the following? (C# inspired).

DECLARE @isExpress bit;
set @isExpress = @edition.StartsWith('Express Edition');

推荐答案

StartsWith

a) left(@edition, 15) = 'Express Edition'
b) charindex('Express Edition', @edition) = 1

包含

charindex('Express Edition', @edition) >= 1

示例

left 功能

set @isExpress = case when left(@edition, 15) = 'Express Edition' then 1 else 0 end

iif 函数(从 SQL Server 2012 开始)

iif function (starting with SQL Server 2012)

set @isExpress = iif(left(@edition, 15) = 'Express Edition', 1, 0);

charindex 功能

set @isExpress = iif(charindex('Express Edition', @edition) = 1, 1, 0);

这篇关于t sql 中是否有 StartsWith 或 Contains 变量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！