数据开发-经典 1.按姓氏笔画排序:, k' e O. \) }% R" ?; e
Select * From TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as //从少到多
+ V! `% ~( `: X' S, o 2.数据库加密:! }) T) H' n/ [* D3 x) U
select encrypt('原始密码')
* T8 I* P9 }' P7 P6 R8 n% ] select pwdencrypt('原始密码')
G* e7 U/ A2 v0 u8 C* j+ n4 J) L select pwdcompare('原始密码','加密后密码') = 1--相同;否则不相同 encrypt('原始密码')
! a f W8 Y: ~: V. h$ ?6 m select pwdencrypt('原始密码')' O8 h& N3 S3 I7 e, v5 f
select pwdcompare('原始密码','加密后密码') = 1--相同;否则不相同
8 @' U) H l3 W/ [/ E+ J0 W) J 3.取回表中字段:
4 V. O8 I( C8 k$ x, S declare @list varchar(1000),& E0 G7 F: t& I4 n K. G* v1 b
@sql nvarchar(1000)
2 q) `) A' D8 Z select @list=@list+','+b.name from sysobjects a,syscolumns b where a.id=b.id and a.name='表A'
" h, P* C* R8 d1 ~* Q' R4 u set @sql='select '+right(@list,len(@list)-1)+' from 表A'7 F) n* [: X0 i
exec (@sql)
( f) Y; ~" `1 W7 o2 x' V 4.查看硬盘分区:
; d! c" Y; S0 | EXEC master..xp_fixeddrives- n- ]6 @1 F9 v4 }
5.比较A,B表是否相等:5 Z/ Y. ?% p, p8 M
if (select checksum_agg(binary_checksum(*)) from A)
( o z9 t3 {& h, h =4 ?# V! z/ e4 b. a7 u) D) m3 p
(select checksum_agg(binary_checksum(*)) from B)% B% c8 k1 ~, o
print '相等'
& B6 u7 ]3 x) l) ~5 n. H else
% M: k: ~. z$ D' D8 S w& D7 N) E" ]6 b! ^, W& L% ^( ]
print '不相等' |