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
Ïà¹ØÎĵµ£º
create table #a
(
a int identity(1,1) primary key,
b int default(0) not null,
c nvarchar(20)
)
insert into #a(c)
select 'a' union all
select 'b' union all
select 'c' union all
select 'd' union all
select 'e'
select * from #a
alter table #a drop constraint DF__#a_____________b__12 ......
SQLServerºÍOracleÊÇ´ó¼Ò¾³£Óõ½µÄÊý¾Ý¿â£¬Ôڴ˸Ðл×÷Õß×ܽá³öÕâЩ³£Óú¯ÊýÒÔ¹©´ó¼Ò²Î¿¼¡£
Êýѧº¯Êý£º
¡¡1.¾ø¶ÔÖµ
¡¡¡¡ S:SELECT abs(-1) value
¡¡¡¡ O:SELECT abs(-1) value from dual
2.È¡Õû(´ó)
¡¡¡¡ S:SELECT ceiling(-1.001) value
¡¡¡¡ O:SELECT ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£© ......
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 ......
Áª½ÓÌõ¼þ¿ÉÔÚ from »ò WHERE ×Ó¾äÖÐÖ¸¶¨£¬½¨ÒéÔÚ from ×Ó¾äÖÐÖ¸¶¨Áª½ÓÌõ¼þ¡£WHERE ºÍ HAVING ×Ó¾äÒ²¿ÉÒÔ°üº¬ËÑË÷Ìõ¼þ£¬ÒÔ½øÒ»²½É¸Ñ¡Áª½ÓÌõ¼þËùÑ¡µÄÐС£
Áª½Ó¿É·ÖΪÒÔϼ¸Àࣺ   ......
¡¡Ç°Ì᣺°²×°sqlserver£¬°²×°outlook£¬outlookÒѾÕýÈ·ÅäÖá£
£¨1£©ÅäÖÃsqlserverµÄÆô¶¯Óû§ÎªÓòÓû§¡£sqlserverÆô¶¯Ä¬Èϵı¾µØÕË»§£¬±¾µØÕË»§Æô¶¯µÄ·þÎñÊÇÎÞ·¨Íê³ÉÓʼþµÄ·¢ËͽÓÊܹ¦Äܵġ£
ÅäÖÃÓòÓû§Æô¶¯£º´ò¿ª¿ØÖÆÃæ°åµÄ--¹ÜÀí¹¤¾ß--·þÎñ£¬ÕÒµ½sqlserver·þÎñ£¬²é¿´ÊôÐÔ¡£Ô ......