测试语句:
declare @i int set @i=1
while(@i<=30)
begin
select * from CF_Department
where DepartmentName like '%[!34]%'
print @i set @i=@i+1
end
------------------分------------------割------------------线------------------
1.TOP效率
SQL Server TOP 的语法:
SELECT TOP number|percent column_name(s)FROM table_name
但是number比percent效率更高,
且随着查询量越少越明显。