注册
登录
| 关键词： ECHO Myuploadtable bat upload width Server Dirlist LogFile 5249464618990 SQL |
转载: 情感网络联盟December 14, 2004Upload multiple files to SQL Server Image columnBy Muthusamy Anantha Kumar aka The MAK翻译:xiaolu这篇文章是个上传多个文件到Ms sqlserver的image类型字段的例子，很多办法可以做到，我想介绍的这种方法利用了OSQL.exe和TEXTCOPY.exe工具。 先决条件：a.必须安装了ms sqlsever 2000的客户端工具b.sql的用户必须至少是dbowner权限步骤：1．建立upload.bat,内容如下： @ECHO offclsREM ECHO onREM Objective: To upload all the files in the folder to SQL server as a tableREM created by: MAKREM Date: Nov 3, 2004REM Contact: [email protected] Check parametersif "%1"=="" Goto noparmErrif "%1"=="/?" Goto HelpREM assign variablesset Sourcefolder=%1set servername=%2set Databasename=%3set loginname=%4set password=%5set LogFile=%6Date/t > %6time /t >> %6REM Export DIR listing to Dirlist.txtdir %1 /b > Dirlist.txtOSQL /S%2 /U%4 /P%5 /d%3 /Q "if exists (select * from %3.dbo.sysobjects where id = object_id(N'[Myuploadtable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table %3.dbo.[Myuploadtable] " >> %6OSQL /S%2 /U%4 /P%5 /d%3 /Q "create table %3.dbo.Myuploadtable (id varchar(500),ImageFiles Image)" >> %6FOR /F "usebackq delims==" %%i in (Dirlist.txt) do OSQL /S%2 /U%4 /P%5 /Q "insert into %3.dbo.Myuploadtable (id,ImageFiles) values('%%i',' ') " >> %6FOR /F "usebackq delims==" %%i in (Dirlist.txt) do textcopy.exe /S%2 /U%4 /P%5 /D%3 /Tmyuploadtable /CImagefiles /F"%1%%i" /I /W"where [id]='%%i'" >> %6GOTo END2:noparmErrEcho Usage help: example as followsecho ...Echo Objective: To upload all the files in the folder to SQL server Table Echo created by: MAKEcho USAGE:ECHO ....ECHO ....Echo %0 SourceFolder Servername Databasename Login Password LogFileGoto END2:HelpEcho Usage help: example as followsecho ...Echo Objective: To upload all the files in the folder to SQL server Table Echo created by: MAKEcho USAGE:ECHO ....ECHO ....Echo %0 SourceFolder Servername Databasename Login Password LogfileGoto END2:ENDEcho "Compare Query results Completed" >>%LogFile%date/t >> %LogFile%time/t >> %LogFile%goto END2:END22．把textcopy.Exe从Microsoft SQL Server\MSSQL\Binn目录拷贝到upload.bat同一目录。3．运行upload.bat,参数如下：screen.width-300)this.width=screen.width-300" border=0>Upload - bat文件名C:\myfiles\ - 所有要传的文件目录（放在一个目录下）SQL - sqlserver的网络名称或者ip地址MyDB - 数据库名（必须存在） sa - 数据库用户名yeahright - 数据库密码x.log - 本地log文件screen.width-300)this.width=screen.width-300" border=0> select ID from Myuploadtable01-2004-08-20-.wav Pfizer 12625.doc STARTSQL.bat status.bat STOPSQL.bat sysperfinfo.zipTech Interview.xls Unix.bat Taiwan.zipselect * from Myuploadtable01-2004-08-20-.wav 0x5249464618990A00574Pfizer 12625.doc 0xD0CF11E0A1B11AE STARTSQL.bat 0x6E65742073746F7D status.bat 0x6E6574207374617SDF STOPSQL.bat 0x6E65742073746FDF sysperfinfo.zip 0x5249464618990A00574 Tech Interview.xls 0xD0CF11E0A1B11AEDF Unix.bat 0x6E65742073746F7DER Taiwan.zip 0x5249464618990A00DE |
|
声明：文章版权归原作者所有 部分文章转自互联网 如有侵权请联系
[邮箱地址] 删除
|
