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

Wad2A5{7xMd I0SELECT * FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',IXPUB技术博客-Na*l3Y*k_A
'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactionsIXPUB技术博客iBO-k i3z%U1DB)s.T
/*动态文件名
SP;M-o4@'q0declare @fn varchar(20),@s varchar(1000)
)[f-hZ]+Z*H` t0set @fn = 'c:\test.xls'
'GE#|V7lEf0set @s ='''Microsoft.Jet.OLEDB.4.0'',IXPUB技术博客W;N{y {5td@o]
''Data Source="'+@fn+'";User ID=Admin;Password=;Extended properties=Excel 5.0'''
?7I${)\,su sa0set @s = 'SELECT * FROM OpenDataSource ($'">'+@s+')...sheet1$'
J \(q.uV\0exec(@s)IXPUB技术博客(E9k.ZP;d5e)t
*/

SELECT cast(cast(科目编号 as numeric(10,2)) as nvarchar(255))+'　' 转换后的别名
k![Xr ~:YK`2k`0FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
"c n-O6[mg|#IJ_0'Data Source="c:\test.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...xactions

6|QNCj;FCK0