* Z- w! L% H8 |5 Q/ |3 L3 N//保存查询的结果, y3 g r7 w& @$ C4 c
3 s, E+ U* h7 }( R+ s# c" ustep1 : ‘; begin declare @var varchar(8000) set @var=’:’ select @var=@var+’+login+’/'+password+’ ‘ from users where login > @var select @var as var into temp end –! p& ]0 w, B! r) ?
. c1 V( L: m' @+ o//取得信息 & x9 V [% H9 _5 g, I8 a * U" a3 B' S& j( Y1 l$ cstep2 : ‘ and 1 in (select var from temp)–6 C5 u: C# k8 v: h; V
1 r9 b% Q+ j7 E: d
//删除临时表& C% @2 E b# R' d
3 j9 L3 s9 e, h. P7 I, a
step3 : ‘ ; drop table temp – / s; I. G) Z- J& \+ ]# J9 \) S6 C) B# \' T8 r$ u
1 g' i6 g. F6 Q# V% a ' p& i- P* F1 Z: |6 t( Y6、创建数据库帐号 # o# P/ j' H' }' ]0 G5 d! C! b9 T$ C7 O) a4 W
MS SQL6 Z* ?9 ?# p0 R: p