新人求助!!!
建表语言(SQLSERVEL数据库):create table [A]
(
[ID] int IDENTITY (1,1) PRIMARY KEY ,
[NAME] nVarChar(50) ,
[SEX] nVarChar(50) ,
)
A表上建立索引CREATE INDEX name
ON A (name)
插入:INSERT INTO A VALUES多条('ASD','1')和少量('QWE','1')
查询语句:select * from A WHERE NAME LIKE REVERSE('EW%')
是否比select * from A WHERE NAME LIKE '%WE'
的效率高???