买拐的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
goselect * from ta
where col like 'a%' or col is not null
/*col
--------------------
a
asfd*/
drop table ta
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
goselect * from ta
where col like 'a%' or col is not null
/*col
--------------------
a
asfd*/
drop table ta
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
goselect * from ta
where col like 'a%' or col is not null
/*
col
--------------------
a
asfd
dfsa
ffa(6 行受影响)
*/我能显示6行
-- Author:
-- Date : 2009-05-06 23:22:34
-- Ver: Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
-- Apr 14 2006 01:12:25
-- Copyright (c) 1988-2005 Microsoft Corporation
-- Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
--
------------------------------------------------------------------------
col
--------------------
a
asfd
dfsa
ffa(所影响的行数为 6 行)
2000
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)