SQL语句，数据库开发语句（四）

1.按姓氏笔画排序:

//从少到多
Select * From TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as

2.取回表中字段

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)

3.查看硬盘分区

EXEC master..xp_fixeddrives

4.比较A,B表是否相等

if (select checksum_agg(binary_checksum(*)) from A)
     =
    (select checksum_agg(binary_checksum(*)) from B)
print '相等'
else
print '不相等'

5.杀掉所有的事件探察器进程

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 '?'