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

SQLÅúÁ¿¸ü¸ÄÓû§±íÄÚ×Ö·ûÐÍ×ֶεÄÅÅÐò¹æÔò

--------------------------------------------------------------------------
--  Author : htl258(Tony)
--  Date   : 2010-04-23 20:33:15
--  Version:Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)
--          Jul  9 2008 14:43:34
--          Copyright (c) 1988-2008 Microsoft Corporation
--          Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
--  Blog   : http://blog.csdn.net/htl258
--  Subject: ÅúÁ¿¸ü¸ÄÓû§±íÄÚ×Ö·ûÐÍ×ֶεÄÅÅÐò¹æÔò
--------------------------------------------------------------------------
DECLARE @S NVARCHAR(1000)
DECLARE C CURSOR FOR --²»Çø·Ö´óСд
    SELECT 'ALTER TABLE ['+B.NAME+'] ALTER COLUMN ['+A.NAME+'] '+ TYPE_NAME(A.XTYPE)+
        CASE WHEN TYPE_NAME(A.XTYPE) IN('TEXT','NTEXT') THEN '' ELSE
            QUOTENAME(A.LENGTH,'(')
        END +' COLLATE CHINESE_PRC_CI_AS' 
    from SYSCOLUMNS A
        JOIN SYSOBJECTS B ON A.ID=B.ID AND B.TYPE='U'
    WHERE TYPE_NAME(A.XTYPE) IN('VARCHAR','CHAR','NVARCHAR','NCHAR','TEXT','NTEXT')
OPEN C
FETCH C INTO @S
WHILE @@FETCH_STATUS=0
BEGIN
    EXEC(@S)
    FETCH C INTO @S
END
CLOSE C
DEALLOCATE C
GO
--×¢£ºÖ÷¼üÔ¼ÊøÓëÍâ¼üÔ¼ÊøµÄ×Ö¶ÎÔÚ´Ë´úÂëÖÐû¿¼ÂÇ¡£


Ïà¹ØÎĵµ£º

Éî¶È¶Ô±ÈOracleÓëSQL Server – µÚÒ»²¿·Ö


²Ù
×÷ϵͳµÄÖ§³Ö
°æ
±¾ºÍ·¢Ðаæ
ʵ
Àý¡¢Êý¾Ý¿âºÍ±í¿Õ¼ä
ʵ
ÀýÃûºÍSID
ϵ
ͳÊý¾Ý¿âºÍϵͳ±í¿Õ¼ä
 
±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊð
Ãû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉЭÒé
·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºS ......

SQL SERVERÖÐÒ»Ð©ÌØ±ðµØ·½µÄÌØ±ð½â·¨

SQL code
/*----------------------------------------------------------------
-- Author :feixianxxx(poofly)
-- Date :2010-04-20 20:10:41
-- Version:
-- Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
Mar 29 2009 10:27:29
Copyright (c) 1988-2008 Microsoft Co ......

sqlÈÕÆÚת»»²ÎÊý

sqlÈÕÆÚת»»²ÎÊý
--ÈÕÆÚת»»²ÎÊý,ÖµµÃÊÕ²Ø
select CONVERT(varchar, getdate(), 120)
2004-09-12 11:06:08
select convert(varchar(10),getdate() ,120) 
----------
2009-04-09
select replace(replace(replace(CONVERT(varchar, getdate(), 120 ),'-',''),' ',''),':','')
20040912110608
select CONVERT( ......

sqlÓï¾ä»ñÈ¡±¾ÖÜ¡¢ÉÏÒ»ÖÜ¡¢±¾ÔÂÊý¾Ý


±¾ÖÜ
select * from tb where datediff(week , ʱ¼ä×Ö¶Î ,getdate()) = 0
ÉÏÖÜ
select * from tb where datediff(week , ʱ¼ä×Ö¶Î ,getdate()) = 1
ÏÂÖÜ
select * from tb where datediff(week , ʱ¼ä×Ö¶Î ,getdate()) = -1
------------------------------------------------------------------------------------ ......

11 SQLµ÷ÓŸÅÊö

11.3µ÷ÓųÌÐò/¼õÇá¸ºÔØ
Èç¹ûÆÚÍû¼õÇáÊý¾Ý¿â·þÎñÆ÷ÕûÌåµÄCPU»òÕßI/O¸ºÔØ£¬¿Éͨ¹ýÒÔϲ½ÖèÈ·¶¨×ÊÔ´Ãܼ¯Ð͵ÄSQLÓï¾ä£º
1.Ñ¡ÔñÔÚÓ¦ÓóÌÐòµÄ´¦Àí¸ß·åÆÚ¼ì²â¡£
2.ÔÚÒÔÉÏÖÜÆÚÄÚ£¬ÊÕ¼¯²Ù×÷ϵͳ¼°Oracleͳ¼ÆÐÅÏ¢¡£ÐèÒªÊÕ¼¯µÄOracleͳ¼ÆÐÅÏ¢ÖÁÉÙ°üÀ¨ÎļþµÄI/O£¨Í¨¹ýÊÓͼV$FILESTAT£©£¬ÏµÍ³Í³¼ÆÐÅÏ¢£¨V$SYSSTAT£©£¬ÒÔ¼°SQLͳ¼ÆÐÅÏ¢£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ