SQL实例

查找表中重复项

select   *   from   student
  where   named     in
  (select   named   from   student   group   by   named   having   sum(1)>1)

SQL语句循环

declare @i int
set @i=1
while @i<30
begin
insert into test (userid) values(@i)
set @i=@i+1
end

---------------

while 条件
begin
执行操作
set @i=@i+1
end

大数据存储过程分页(只适合SQL2005+版本)
select Businesstype,Intorductionid,userid,UserName,typename,Commentscount,digno,ops,Businessmap,Businessid,Alias,convert(char(10),Addtime,120) as Addtime,id,
ROW_NUMBER() OVER(order by Addtime)
as row from f_list
) a 
where a.row between @pageindex*6-6 and @pageindex*6