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

SQLÊý¾Ý¿â

1.      ´æ´¢¹ý³Ì(¶¨Òå&±àд)
l  ´´½¨´æ´¢¹ý³Ì
CREATE PROCEDURE storedproc1
AS
SELECT *
from tb_project
WHERE  Ô¤¼Æ¹¤ÆÚ<= 90
ORDER BY  Ô¤¼Æ¹¤ÆÚ DESC
GO
exec storedproc1
GO
 
l   Ð޸Ĵ洢¹ý³Ì
ALTER PROCEDURE storedproc1
AS
SELECT ÏîÄ¿Ãû³Æ,Ô¤¼Æ¹¤ÆÚ
from tb_project
WHERE Ô¤¼Æ¹¤ÆÚ>=90
ORDER BY Ô¤¼Æ¹¤ÆÚ DESC
GO
exec storedproc1
GO
 
CREATE PROCEDURE store7
@name varchar(10),@avgpbiaodi int OUTPUT
AS
DECLARE @errorsave int
SET @errorsave=0
SELECT @avgpbiaodi=AVG(Ô¤¼Æ¹¤ÆÚ)
from tb_project AS p INNER JOIN tb_employee AS e
ON p.¿Í»§±àºÅ= e.±àºÅ
WHERE e.ÐÕÃû=@name
IF(@@error<>0)
SET @errorsave=@@error
RETUREN @errorsave
GO
DECLARE @returnvalue int,@avg int
exec @returnvalue=store7 'ËïСÀö',@avg OUTPUT
PRINT 'Ö´ÐеĽá¹û'
PRINT '·µ»ØÖµ='+CAST(@returnvalue AS char(2))
PRINT 'sun¸ºÔðÏîÄ¿µÄƽ¾ù¹¤ÆÚ£º'  +CAST(@avg AS char(10))
GO
 
 
 
2.      EXEC &GO(ʹÓô洢¹ý³Ì)
 
l  ²é¿´´æ´¢¹ý³Ì
 
EXEC sp_helptext storedproc1
EXEC sp_depends storedproc1
EXEC sp_help storedproc1  ---ÔÚµ±Ç°Êý¾Ý¿âÖвéÕÒ¶ÔÏó
 
ʵÀý239//////////////////////////////
USE sml
GO
CREATE VIEW ÊÓͼ
AS
SELECT *
from tb_employee
WHERE ¹¤×Ê=600
EXEC sp_helptext 'ÊÓͼ'  --ÏÔʾ¸Ã¶ÔÏóµÄ¶¨ÒåÐÅÏ¢,¶ÔÏó±ØÐëÔÚµ±Ç°Êý¾Ý¿âÖÐ
USE sml
EXEC sp_depends 'ÊÓͼ'  --±»¼ì²éÏà¹ØÐеÄÊý¾Ý¿â¶ÔÏó,¶ÔÏó¿ÉÒÔÊDZí,ÊÓͼ,´æ´¢¹ý³Ì,»ò´¥·¢Æ÷,¶ÔÏóµÄ--Êý¾ÝÀàÐÍΪvarchar(766).ÈôÒ»¸ö¶ÔÏóÒýÓÃÁíÒ»¸ö¶ÔÏó,ÔòÈËȨÚÀǰÕßÒÀÀµºóÕß,ͨ¹ý¼ì²ésysdepends±í--È·¶¨Ïà¹ØÐÔ
GO
 
//////////////////////////////////
EXEC sp_rename'ÈËÔ±±í','ÈËÔ±ÐÅÏ¢±í'
EXEC sp_rename'ÈËÔ±ÐÅÏ¢±í.µç»°','ÁªÏµµç»°','COLUMN'
 
EXEC sp_detach_db @dbname = 'pubs'
EXEC sp_attach_single_file_db @dbname = 'pubs',
   @physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
 
////////////////////
USE master
EXEC sp_addextendedproc xp_hello, 'xp


Ïà¹ØÎĵµ£º

SQLSERVER SQLÐÔÄÜÓÅ»¯

1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......

SQL Server 2005ÖеÄÎļþºÍÎļþ×é

1¡¢ÎļþºÍÎļþ×éµÄº¬ÒåÓë¹ØÏµ
    Ã¿¸öÊý¾Ý¿âÓÐÒ»¸öÖ÷Êý¾ÝÎļþ.ºÍÈô¸É¸ö´ÓÎļþ¡£ÎļþÊÇÊý¾Ý¿âµÄÎïÀíÌåÏÖ¡£ Îļþ×é¿ÉÒÔ°üÀ¨·Ö²¼ÔÚ¶à¸öÂß¼­·ÖÇøµÄÎļþ£¬ÊµÏÖ¸ºÔØÆ½ºâ¡£Îļþ×éÔÊÐí¶ÔÎļþ½øÐзÖ×飬ÒÔ±ãÓÚ¹ÜÀíºÍÊý¾ÝµÄ·ÖÅ䣯·ÅÖá£ÀýÈ磬¿ÉÒÔ·Ö±ðÔÚÈý¸öÓ²ÅÌÇý¶¯Æ÷ÉÏ´´½¨Èý¸öÎļþ£¨Data1.ndf¡¢Data2.ndf&nb ......

Oracle ¶¯Ì¬SQL·µ»Øµ¥Ìõ½á¹ûºÍ½á¹û¼¯

Oracle ¶¯Ì¬SQL·µ»Øµ¥Ìõ½á¹ûºÍ½á¹û¼¯
1. DDL ºÍ DML
/**//*** DDL ***/
begin
    EXECUTE IMMEDIATE 'drop table temp_1';
    EXECUTE IMMEDIATE 'create table temp_1(name varchar2(8))';
end;
/**//*** DML ***/
declare
    v_1 varchar2(8);
 & ......

sqlÓï¾äÓÅ»¯2

£¨18£©ÓÃEXISTSÌæ»»DISTINCT£º
µ±Ìá½»Ò»¸ö°üº¬Ò»¶Ô¶à±íÐÅÏ¢(±ÈÈ粿ÃűíºÍ¹ÍÔ±±í)µÄ²éѯʱ,±ÜÃâÔÚSELECT×Ó¾äÖÐʹÓÃDISTINCT¡£Ò»°ã¿ÉÒÔ¿¼ÂÇÓÃEXISTÌæ»», EXISTS Ê¹²éѯ¸üΪѸËÙ,ÒòΪRDBMSºËÐÄÄ£¿é½«ÔÚ×Ó²éѯµÄÌõ¼þÒ»µ©Âú×ãºó,Á¢¿Ì·µ»Ø½á¹û¡£Àý×Ó£º
(µÍЧ):
SELECT DISTINCT DEPT_NO,DEPT_NAME  ......

¶Á¡¶SQL Server 2005¸ß¼¶¹ÜÀí¡·µÄһЩժҪ... Á¬ÔØ5

ÔÚT-SQLÖмàÊÓ½ø³Ì
DBA¸üÔ¸ÒâʹÓÃT-SQLµÄÔ­ÒòÊÇ¿ÉÒԱȓ»î¶¯¼àÊÓÆ÷”¸ü¼ÓÁé»îµØ»ñµÃÐÅÏ¢¡£
1.       sp_whoºÍsp_who2
´æ´¢¹ý³Ìsp_whoÒ²·µ»Øµ±Ç°Á¬½ÓÊý¾Ý¿âʵÀý£¬Ó듻¼àÊÓÆ÷”·Ç³£ÀàËÆ¡£È»¶ø£¬Óû§¿ÉÄÜ·¢ÏÖ×Ô¼º¸üÔ¸ÒâʹÓÃδ¹«¿ªËµÃ÷µÄsp_who2´æ´¢¹ý³Ì£¬ÒòΪËüÌṩ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ