Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¼òµ¥µÄ sql·ÖÒ³´æ´¢¹ý³Ì

¡¾1¡¿
create procedure proc_pager1  
(   @pageIndex int, -- ҪѡÔñµÚXÒ³µÄÊý¾Ý 
    @pageSize int -- ÿҳÏÔʾ¼Ç¼Êý 
)  
AS 
BEGIN 
   declare @sqlStr varchar(500)  
   set @sqlStr='select top '+convert(varchar(10),@pageSize)+  
    ' * from orders where orderid not in(select top '+  
    convert(varchar(20),(@pageIndex-1)*@pageSize)+  
    ' orderid from orders) order by orderid' 
    exec (@sqlStr)  
END 
¡¾2¡¿
 create procedure proc_pager  
(   @startIndex int,--¿ªÊ¼¼Ç¼Êý 
    @endIndex int   --½áÊø¼Ç¼Êý 
)  
as 
begin 
declare @indextable table(id int identity(1,1),nid int)  
insert into @indextable(nid) select orderid from orders order by orderid desc 
select *   
from orders o  
inner join @indextable i  
on o.orderid=i.nid  
where i.id between @startIndex and @endIndex  
order by i.id  
end 
 
¡¾3¡¿ÊÊÓÃÓÚsql2005 
create procedure proc_pager2  
(   @startIndex int,--¿ªÊ¼¼Ç¼Êý 
    @endIndex int   --½áÊø¼Ç¼Êý 
)  
as 
begin 
WITH temptbl AS   
(SELECT ROW_NUMBER() OVER (ORDER BY orderid DESC) AS Row, *from orders)  
SELECT * from temptbl  
where row between @startIndex and @endIndex  
order by row  
end


Ïà¹ØÎĵµ£º

Ôõô°Ñ sqlÓï¾ä²éѯµÄÖµ¸³¸ø±äÁ¿

string str = System.Configuration.ConfigurationManager.AppSettings["strconn"];
string sqlpwd = "select password from bg_user where username='" + username + "'";
MySqlConnection conn = new MySqlConnection(str);
MySqlCommand cmd=new MySqlCommand(sqlpwd,conn);
MySqlDataAdapter adr = new MySqlDataA ......

SQL XML DELETE

--A. ´Ó´æ´¢ÔÚ·ÇÀàÐÍ»¯µÄ xml ±äÁ¿ÖеÄÎĵµÖÐɾ³ý½Úµã
DECLARE @myDoc xml
SET @myDoc = '<?Instructions for=TheWC.exe ?>
<Root>
 <!-- instructions for the 1st work center -->
<Location LocationID="10" LaborHours="1.1" MachineHours=".2" >
 Some text 1
 <st ......

SQL SERVER¿ç·þÎñÆ÷²éѯ(SQL SERVER DBLINK)

--¿ç·þÎñÆ÷²éѯÈçÏ£º
SELECT a.*,b.stor_Name
from OPENROWSET('MSDASQL',
   'DRIVER={SQL Server};SERVER=tom;UID=sa;PWD=123',
   pubs.dbo.authors) AS a,stores b
ORDER BY a.au_lname, a.au_fname
--ÆäÖУ¬tomΪԶ³Ì·þÎñÆ÷Ãû£¬stores ÊDZ¾»úÊý¾Ý¿âpubsÖеıí
--ÐèҪעÒâµÄÊÇÈô¶þ¸ö±íÖÐµÄ ......

sql server 2000¹ÒÆð´íÎó´¦ÀíÕûÀí

ÐÂ×°»òÕßÒÔǰװ¹ýsql server£¬ºóÀ´É¾µô¡£ÏÖÔÚ֨װ£¬»á³öÏÖ“ÒÔǰµÄij¸ö³ÌÐò°²×°ÒÑÔÚ°²×°¼ÆËã»úÉÏ´´½¨¹ÒÆðµÄÎļþ²Ù×÷£¬ÔËÐа²×°³ÌÐò֮ǰ±ØÐëÖØÐÂÆô¶¯¼ÆËã»ú”´íÎó¡£ÎÞ·¨½øÐÐÏÂÈ¥¡£
ÒÔÏÂΪ½â¾ö²½Ö裺
1£©Ìí¼Ó/ɾ³ý³ÌÐòÖг¹µ×ɾ³ýsql server¡£
2£©½«Ã»ÓÐɾ³ýµÄsql serverĿ¼Ҳɾ³ýµô¡£
3£©´ò¿ª×¢²á±í±à¼­Æ÷£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ