SQL Êý¾Ý¿â¿ª·¢Ò»Ð©¾«µäµÄ´úÂë

1.°´ÐÕÊϱʻ­ÅÅÐò: Select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
2.Êý¾Ý¿â¼ÓÃÜ: select encrypt('ԭʼÃÜÂë') select pwdencrypt('ԭʼÃÜÂë') select pwdcompare('ԭʼÃÜÂë','¼ÓÃܺóÃÜÂë') = 1--Ïàͬ£»·ñÔò²»Ïàͬ
3.È¡»Ø±íÖÐ×Ö¶Î: declare @list varchar(1000),@sql nvarchar(1000)  select @list=@list+','+b.name from sysobjects a,syscolumns b where a.id=b.id and a.name='±íA' set @sql='select '+right(@list,len(@list)-1)+' from ±íA'  exec (@sql)
4.²é¿´Ó²ÅÌ·ÖÇø: EXEC master..xp_fixeddrives
5.±È½ÏA,B±íÊÇ·ñÏàµÈ: if (select checksum_agg(binary_checksum(*)) from A)     =    (select checksum_agg(binary_checksum(*)) from B) print 'ÏàµÈ' else print '²»ÏàµÈ'
6.ɱµôËùÓеÄʼþ̽²ìÆ÷½ø³Ì: DECLARE hcforeach CURSOR GLOBAL FOR SELECT 'kill '+RTRIM(spid) from master.dbo.sysprocesses WHERE program_name IN('SQL profiler',N'SQL ʼþ̽²éÆ÷') EXEC sp_msforeach_worker '?'
7.È¡Ö¸¶¨Î»ÖõļǼ: --¿ªÍ·µ½NÌõ¼Ç¼ Select Top N * from ±í ------------------------------- --Nµ½MÌõ¼Ç¼(ÒªÓÐÖ÷Ë÷ÒýID) Select Top M-N * from ±í Where ID in (Select Top M ID from ±í) Order by ID Desc ---------------------------------- --Nµ½½áβ¼Ç¼ Select Top N * from ±í Order by ID Desc
8.ÐÞ¸ÄÊý¾Ý¿âµÄÃû³Æ: sp_renamedb 'old_name', 'new_name'
9£º»ñÈ¡µ±Ç°Êý¾Ý¿âÖеÄËùÓÐÓû§±í select Name from sysobjects where xtype='u' and status>=0
10£º»ñȡijһ¸ö±íµÄËùÓÐ×ֶΠselect name from syscolumns where id=object_id('±íÃû')
11£º²é¿´Óëijһ¸ö±íÏà¹ØµÄÊÓͼ¡¢´æ´¢¹ý³Ì¡¢º¯Êý select a.* from sysobjects a, syscomments b where a.id = b.id and b.text like '%±íÃû%'
12£º²é¿´µ±Ç°Êý¾Ý¿âÖÐËùÓд洢¹ý³Ì select name as ´æ´¢¹ý³ÌÃû³Æ from sysobjects where xtype='P'
13£º²éѯÓû§´´½¨µÄËùÓÐÊý¾Ý¿â select * from master..sysdatabases D where sid not in(select sid from master..syslogins where name='sa') »òÕß select dbid, name AS DB_NAME from master..sysdatabases where sid <> 0x01
14£º²éѯijһ¸ö±íµÄ×ֶκÍÊý¾ÝÀàÐÍ select column_name,data_type from information_schema.columns where table_n