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

ÇÉÓÃSQLµÄÈ«¾ÖÁÙʱ±í·ÀÖ¹Óû§Öظ´µÇ¼

ÇÉÓÃSQLµÄÈ«¾ÖÁÙʱ±í·ÀÖ¹Óû§Öظ´µÇ¼
ÎÄÕÂÀ´×Ô£ºhttp://www.cnblogs.com/lindayyh/archive/2010/04/05/1704763.html
ÔÚÎÒÃÇ¿ª·¢ÉÌÎñÈí¼þµÄʱºò£¬³£³£»áÓöµ½ÕâÑùµÄÒ»¸öÎÊÌ⣺ÔõÑù·ÀÖ¹Óû§Öظ´µÇ¼ÎÒÃǵÄϵͳ£¿ÌرðÊǶÔÓÚÒøÐлòÊDzÆÎñ²¿ÃÅ£¬¸üÊÇÒªÏÞÖÆÓû§ÒÔÆä¹¤ºÅÉí·Ý¶à´ÎµÇÈë¡£
¿ÉÄÜ»áÓÐÈË˵ÔÚÓû§ÐÅÏ¢±íÖмÓÒ»×Ö¶ÎÅжÏÓû§¹¤ºÅµÇ¼µÄ״̬£¬µÇ¼ºóд1£¬Í˳öʱд0£¬ÇҵǼʱÅÐ¶ÏÆä±ê־λÊÇ·ñΪ1£¬ÈçÊÇÔò²»ÈøÃÓû§¹¤ºÅµÇ¼¡£µ«ÊÇÕâÑùÄÇÊÆ±Ø»á´øÀ´ÐµÄÎÊÌ⣺Èç·¢ÉúÏó¶ÏµçÖ®À಻¿ÉÔ¤ÖªµÄÏÖÏó£¬ÏµÍ³ÊÇ·ÇÕý³£Í˳ö£¬ÎÞ·¨½«±ê־λÖÃΪ0£¬ÄÇôÏ´ÎÒÔ¸ÃÓû§¹¤ºÅµÇ¼Ôò²»¿ÉµÇÈ룬Õâ¸ÃÔõô°ìÄØ£¿
»òÐíÎÒÃÇ¿ÉÒÔ»»Ò»ÏÂ˼·£ºÓÐʲô¶«Î÷ÊÇÔÚconnection¶Ï¿ªºó¿ÉÒÔ±»ÏµÍ³×Ô¶¯»ØÊÕµÄÄØ£¿¶ÔÁË£¬SQL ServerµÄÁÙʱ±í¾ß±¸Õâ¸öÌØÐÔ£¡µ«ÊÇÎÒÃÇÕâÀïµÄÕâÖÖÇé¿ö²»ÄÜÓþֲ¿ÁÙʱ±í£¬ÒòΪ¾Ö²¿ÁÙʱ±í¶ÔÓÚÿһ¸öconnectionÀ´Ëµ¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶ÔÏó£¬Òò´ËÖ»ÄÜÓÃÈ«¾ÖÁÙʱ±íÀ´´ïµ½ÎÒÃǵÄÄ¿µÄ¡£
ºÃÁË£¬Çé¿öÒѾ­Ã÷ÀÊ»°ÁË£¬ÎÒÃÇ¿ÉÒÔдһ¸öÏóÏÂÃæÕâÑù¼òµ¥µÄ´æ´¢¹ý³Ì:
create procedure gp_findtemptable -- 2001/10/26
21:36 zhuzhichao in nanjing
/* ѰÕÒÒÔ²Ù×÷Ô±¹¤ºÅÃüÃûµÄÈ«¾ÖÁÙʱ±í
 * ÈçÎÞÔò½«out²ÎÊýÖÃΪ0²¢´´½¨¸Ã±í,ÈçÓÐÔò½«out²ÎÊýÖÃΪ1
 * ÔÚconnection¶Ï¿ªÁ¬½Óºó,È«¾ÖÁÙʱ±í»á±»SQL Server×Ô¶¯»ØÊÕ
* Èç·¢Éú¶ÏµçÖ®ÀàµÄÒâÍâ,È«¾ÖÁÙʱ±íËäÈ»»¹´æÔÚÓÚtempdbÖÐ,
µ«ÊÇÒѾ­Ê§È¥»îÐÔ
* ÓÃobject_idº¯ÊýÈ¥ÅжÏʱ»áÈÏΪÆä²»´æÔÚ.
 */
@v_userid varchar(6), -- ²Ù×÷Ô±¹¤ºÅ
@i_out int out -- Êä³ö²ÎÊý 0:ûÓеǼ 1:ÒѾ­µÇ¼
as
declare @v_sql varchar(100)
if object_id(''''tempdb.dbo.##''''+@v_userid) is null
begin
set @v_sql = ''''create table ##''''+@v_userid+
''''(userid varchar(6))''''
exec (@v_sql)
set @i_out = 0
end
else
set @i_out = 1
ÔÚÕâ¸ö¹ý³ÌÖУ¬ÎÒÃÇ¿´µ½Èç¹ûÒÔÓû§¹¤ºÅÃüÃûµÄÈ«¾ÖÁÙʱ±í²»´æÔÚʱ¹ý³Ì»áÈ¥´´½¨Ò»ÕŲ¢°Ñout²ÎÊýÖÃΪ0£¬Èç¹ûÒѾ­´æÔÚÔò½«out²ÎÊýÖÃΪ1¡£
ÕâÑù£¬ÎÒÃÇÔÚÎÒÃǵÄÓ¦ÓóÌÐòÖе÷Óøùý³Ìʱ£¬Èç¹ûÈ¡µÃµÄout²ÎÊýΪ1ʱ£¬ÎÒÃÇ¿ÉÒÔºÁ²»¿ÍÆøµØÌø³öÒ»¸ömessage¸æËßÓû§Ëµ”¶Ô²»Æð£¬´Ë¹¤ºÅÕý±»Ê¹Óã¡”
(²âÊÔ»·¾³:·þÎñÆ÷:winnt server 4.0 SQL Server7.0 ¹¤×÷Õ¾:winnt workstation)


Ïà¹ØÎĵµ£º

´æ´¢¹ý³Ì£¬ Éú³ÉSQLÓï¾ä

USE [sfaecrm]
GO
/****** ¶ÔÏó:  StoredProcedure [dbo].[proc_insert]    ½Å±¾ÈÕÆÚ: 05/29/2009 06:16:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER proc [dbo].[proc_insert] (@tablename varchar(256))
as
begin
        set ......

SQLÃüÁî´óÈ« ÖÐÓ¢ÎĶÔÕÕ

[code=SQL][/code]
--Óï ¾ä ¹¦ ÄÜ 
--Êý¾Ý²Ù×÷ 
SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁР
INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐР
DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐР
UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý 
--Êý¾Ý¶¨Òå 
CREATE TABLE --´´½¨Ò»¸öÊý¾Ý¿â±í 
DROP TABLE --´ÓÊý¾Ý ......

SQL Server DBCCÃüÁî


¡ô1.DBCC CacheStats £ºÏÔʾ´æÔÚÓÚµ±Ç° buffer Cache ÖеĶÔÏóµÄÐÅÏ¢£¬ÀýÈç £ºhitrates ±àÒëµÄ¶ÔÏóºÍÖ´Ðмƻ®
 
DBCC CACHESTATS
 
¡¡¡¡´ÓÕâ¸öÃüÁî¿ÉÒԵõ½Ò»Ð©¹Ø¼üµÄͳ¼ÆÐÅÏ¢£º
¡¡¡¡Hit Ratio£ºÏÔÊ¾ÌØ¶¨¶ÔÏó¿ÉÒÔÔÚSql ServerµÄ»º´æÖб»ÃüÖеİٷֱȣ¬Õâ¸öÊýÖµÔ½´ó£¬Ô½ºÃ
¡¡¡¡Object Count£ºÏÔ ......

¡¾×ª¡¿ACCESSÖÐÈçºÎÔÚSQLÓï¾äµÄWHEREÌõ¼þÖмÓÈÕÆÚÌõ¼þ

ת×Ô
http://topic.csdn.net/t/20050110/09/3711952.html
accessÖÐʱ¼äÒªÓÃ#,²»ÊÇË«ÒýºÅ  
  select   *   from   kc   where   rq   <   #2000-01-01#   and   rq>#2002-01-01#  
  ²»ÒªÓÃbetween,ËüµÄЧÂÊÌ©µÍ  
ʹÓÃ# ¶ø²»ÊÇ ......

SQlÊý¾Ý¿â¿ìËÙÈëÃűØÐëÕÆÎÕµÄËÄ´ó»ù±¾Óï¾ä

×öÒ»¸öϵͳµÄºǫ́£¬»ù±¾É϶¼ÉÙ²»ÁËÔöɾ¸Ä²é£¬×÷Ϊһ¸öÐÂÊÖÈëÃÅ£¬ÎÒÃDZØÐëÒªÕÆÎÕSQLËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä£ºInsert£¬Select£¬UpdateºÍDelete£¡ ÏÂÃæ¶ÔÕâËĸöÓï¾ä½øÐÐÏêϸµÄÆÊÎö£º
¡¡¡¡ ÊìÁ·ÕÆÎÕSQLÊÇÊý¾Ý¿âÓû§µÄ±¦¹ó²Æ¸»¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃǽ«Òýµ¼ÄãÕÆÎÕËÄÌõ×î»ù±¾µÄÊý¾Ý²Ù×÷Óï¾ä—SQLµÄºËÐŦÄÜ—À´ÒÀ´Î½éÉܱȽ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ