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

sql±àÒëÓëÖØ±àÒë

sql±àÒëÓëÖØ±àÒë
 
1.sp_recompile
ʹ´æ´¢¹ý³ÌºÍ´¥·¢Æ÷ÔÚÏ´ÎÔËÐÐÊ±ÖØÐ±àÒë¡£
2.sp_refreshview
Èç¹ûÊÓͼËùÒÀÀµµÄ»ù´¡¶ÔÏó·¢Éú¸ü¸Ä(Èç:±íÔö¼ÓÁËÒ»¸ö×Ö¶Î)£¬ÔòÊÓͼ²»»á×Ô¶¯¸üУ¬ÕâʱÐèÒªµ÷Óøô洢¹ý³ÌÀ´¶ÔÊÓͼ½øÐÐˢС£ÓÐÈË˵£¬ÖØÐ´ò¿ªÒ»ÏÂÊÓͼ¾Í¿ÉÒÔ¸üÐÂÊÓͼ£¬µ«ÎÒÊÔÁËûÓгɹ¦¡£
Àý1£ºË¢ÐÂÖ¸¶¨Ãû³ÆµÄÊÓͼ
sp_refreshview 'v_tblItem'
Àý2:Ë¢ÐÂÕû¸öÊý¾Ý¿âÖеÄËùÓÐÊÓͼ
 
CREATE PROCEDURE [dbo].[_Proc_CheckView](
    @IsDelete bit=0 --ÊÇ·ñҪɾ³ýÎÞЧµÄÊÓͼ
    )
AS
BEGIN
      
    DECLARE @vName sysname ;
    DECLARE @ErrorMessage nvarchar(200);
    DECLARE @count int;
    SET @count=0;
    DECLARE @ErrorCount int;
    SET @ErrorCount=0;
 
    CREATE TABLE #temp(
       ViewName nvarchar(776)
       )
    DECLARE refresh_cursor CURSOR FOR 
        SELECT Name from sysobjects
        WHERE xtype = 'V'
        AND category=0
        order by crdate
    FOR READ ONLY  
    OPEN refresh_cursor
    FETCH NEXT from refresh_cursor 
    INTO @vName
       WHILE @@FETCH_STATUS = 0
       BEGIN
           BEGIN try
              exec sys.sp_refreshview @vName
           END try
           BEGIN catch
              insert into #temp(ViewName)
 &n


Ïà¹ØÎĵµ£º

Oracle SQLÓï¾ä

ORDER BY ÅÅÐò
 
ASC ÉýÐò(ĬÈÏ)
 DESC ½µÐò
 
select * from s_emp order by dept_id , salary desc
²¿ÃźÅÉýÐò£¬¹¤×ʽµÐò
¹Ø¼ü×ÖdistinctÒ²»á´¥·¢ÅÅÐò²Ù×÷¡£
 
select * from employee order by 1; //°´µÚÒ»×Ö¶ÎÅÅÐò
NULL±»ÈÏΪÎÞÇî´ó¡£order by ¿ÉÒÔ¸ú±ðÃû¡£
 
select table_name ......

pl/sqlÀûÓÃrownumÈ¡µÃÅÅÐòºóµÄ²¿·ÖÐÐÐòÁÐ

ÎÒÃÇʹÓÃoracleµÄÈ˶¼ÖªµÀ¿ÉÒÔͨ¹ýrownumαÁеõ½²éѯ½á¹ûÐòÁÐÇ°ÃæµÄÖ¸¶¨µÄÐУ¬ÎªÁËÏÂÃæ¸üºÃµÄ½øÐÐ˵Ã÷ÎÊÌ⣬ÎÒÃÇÏÈÀ´´´½¨Ò»¸öÊý¾Ý±ítable1£º
create table table1
(AAA integer primary key,
BBB varchar(30));
È»ºóÔÚtable1ÖвåÈë9ÌõÊý¾Ý£º
insert into table1 values (8, 'good');
insert into table1 values (7 ......

10. ¾«ÃîSQL語¾ä

         1. ˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ£¬Ô´±íÃû£ºa£¬Ð±íÃû£ºb)
SQL: select * into b from a where 1<>1;
        2. ˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý£¬Ô´±íÃû£ºa£¬Ä¿±ê±íÃû£ºb)
SQL: insert into b(a, b, c) select d, e, f from b;
&nb ......

Sql Server·¢ÓʼþÅäÖÃ

¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾ­ÕýÈ·ÅäÖá£
    £¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
     ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£Ô ......

Sql Server2005ʵÏÖÔ¶³Ì±¸·ÝÊý¾Ý¿â

 
ÏàÐÅ´ó¼Ò¶¼ÔÚµ±ÐÄÊý¾Ý¿âµÄ¶ªÊ§£¬ÕâÒ²ÊÇÿ¸ö¿ª·¢ÕßÍ·Í´µÄÒ»¼þʼþ£¬ÒòΪÕýÔÚÔËÐеķþÎñÆ÷¼°Êý¾Ý¿âÒ²ÔÚÕą̂·þÎñÆ÷ÉÏ¡£Èç¹û·þÎñÆ÷±ÀÀ££¬ÄÇôËùÓеÄÊý¾Ý
¶¼²»´æÔÚÁË£¬¾ÍËãÊÇÄãÔÚÄãµÄ»ú×ÓÉÏ×öÁ˱¸·Ý£¬ÄÇÒ²ÊÇûÓÐÓõģ¬ÎªÊ²Ã´»áÕâÑù˵Ö÷ÒªÊÇÒòΪ±¾»úÊÇÏò»¥ÁªÍø¹«¿ªµÄ£¬ËùÒÔ³öʹʵĸÅÂʾͱȽϸߡ£×îÖÕÎÒÃÇ¿ÉÒÔÀû
ÓþÖÓò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ