34,576
社区成员
发帖
与我相关
我的任务
分享
create table ta(col varchar(20))
go
create index idx_col on ta(col)
go
insert ta select 'a'
insert ta select ''
insert ta select ' '
insert ta select 'ffa'
insert ta select 'asfd'
insert ta select 'dfsa'
insert ta select null
go
select * from ta
where col like 'a%' or col is not null
/*
col
--------------------
a
asfd
*/
drop table ta
Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
Jul 9 2008 14:43:34
Copyright (c) 1988-2008 Microsoft Corporation
Enterprise Evaluation Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 2)
col
--------------------
a
asfd
dfsa
ffa
(所影响的行数为 6 行)
create table ta(col varchar(20))
go
create index idx_col on ta(col)
go
insert ta select 'a'
insert ta select ''
insert ta select ' '
insert ta select 'ffa'
insert ta select 'asfd'
insert ta select 'dfsa'
insert ta select null
go
select * from ta
where col like 'a%' or col is not null
/*
col
--------------------
a
asfd
dfsa
ffa
(6 行受影响)
*/
我能显示6行