SQL入侵必学语句大全(1)

9OB*Drrk-u7590422SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
8b5FKZDa4zO~7590422'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactionsIXPUB技术博客 _
k vYht
/*动态文件名IXPUB技术博客`:u$p g:_Vw;|$V
declare @fn varchar(20),@s varchar(1000)IXPUB技术博客1]t+g:ra P
set @fn = 'c:\test.xls'IXPUB技术博客L2B{(S%y)hn
set @s ='''Microsoft.Jet.OLEDB.4.0'',
-HC:x Nn G{+I7590422''Data Source="'+@fn+'";User ID=Admin;Password=;Extended properties=Excel 5.0'''IXPUB技术博客
NC5o)J7a$`6st
set @s = 'SELECT * FROM OpenDataSource ($'">'+@s+')...sheet1$'
6T"gi.p5{6bC`Vb5b7590422exec(@s)IXPUB技术博客 m6w%M6w7`3eIX&m%Fa
*/

0Yy.B:[#iw{Rx7590422SELECT cast(cast(科目编号 as numeric(10,2)) as nvarchar(255))+'　' 转换后的别名
.g4]Bl!n(W r
w7590422FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',IXPUB技术博客qHSx }'_[a:b'b
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactionsIXPUB技术博客XX7Wc!b

w;I(bY-x&W!A+T7590422
:b,gv~ eD1z9}7590422IXPUB技术博客8hZX J9|F!b{;Q