SQL Server image viewing tool SQLImageViewer5.5.0.156

SQL Server image viewing tool SQLImageViewer5.5.0.156 was held at a SQLPASS conference in Beijing on December 6, 2013, wang Zhongtao, a veteran of grui trends, introduced a database image viewing tool. I don't know if you are impressed. However, the plug-in introduced in this article is not a tool integrated into SSMS: www. kua

SQL Server Image viewing tool SQL Image 5.5.0.156 at a SQL PASS meeting in Beijing on December 6, 2013, grui trend of Wang Zhongtao Daxia introduced a database image viewing tools do not know if you have any impression, but this article introduces the plug-in is not integrated into SSMS when this tool: http://www.kua

SQLSERVER Image View ToolsSQL Image Viewer5.5.0.156

At a SQL PASS meeting in Beijing in 2013, Dr. Wang Zhongtao of grui trends introduced a databaseImageViewTools

Do you have any impressions?

However, the plug-ins introduced in this article are not integrated into SSMS.

ThisTools: Http://www.kuaipan.cn/file/id_4401224786927352.htm

You can also go to the official website to download: http://www.yohz.com/siv_overview.htm

The official website is very informative.View, Export the data stored in the databaseImageAnd file, andToolsCustomers include Samsung, Siemens, and Sony.

It's a pity that the entire Internet has not been cracked.

The latest version is 5.5.0.156 (). We can see that this software is still being updated. The latest version supports SQLSERVER2012.

Experience

The software supports a variety of databases, not just SQLSERVER, but rather powerful.

You can choose MDAC or SQL Native Client as the database driver.

I select SQL Native Client. The database selects AdventureWorks. Some tables in the AdventureWorks database have binary data types.ImageColumn

There are also file columns of the binary data type, such as Word documents. You can test the function of this software.

After the connection is successful, you can see on the right hand side of the interface that all data tables containing binary data in the entire database have been listed. The lower right corner is SQLSERVER2012 SP1.

Open table definition in SSMS

We write SQL statements and then execute

The result window is divided into two parts:

The preceding window is displayed.Image, The following window shows data rows

Careful friends will find thatImageThe window displays allImageColumn, because only two rows in the table areImageColumn, so only two columns are displayed.Image

SelectImageIt also displaysImage, The followingImageThis attribute is displayedImageYes GIFImage, Length: 240, width: 149, size: 20KB

SelectedImageRight-click, and the right-click menu will pop up.

We can click "save item" to save this image separately.Image

If you want to switch the database, you can use the drop-down list to switch to another database.

ChangeImageThe displayed style can be selected from the drop-down list. Three styles are supported by the software.

The software configuration menu is also relatively simple.

Export Function

The export function can be regarded as a powerful function of this software. It can export allImageOr all files

For exampleImage

Click "Export ".

Select a data source. You can re-compile the SQL statement or use the result set. Because there are three rows of records, there are two records in each row.Image, So a total of 6Image, 6 items

You can select the file type to export, including:Image, Word documents, excel, ppt, etc.

You can exportImagePerform special effects and then export

Select the path to save the exported file andImageRule name

File rules

Click Finish to start exporting

Because it is a trial version, only five items are supported. One item isImage, That is, fiveImage

File names are generated according to rules

File Functions

Let's query the [Production]. [Document] table.

Result

Double-click one of the Word documents, and the software will immediately call the wordsoftware office2010 on the computer to open it.

Export the Word documents in the table

The procedure is the same as that in the previous step. You only need to check Word files when selecting the exported file type in step 2.

As for the special effect, it will not be processed. If it is output as is, it is estimated that the special effect processing here is done in the Word document.Image

Click "finish" to start exporting.

Trial version warning, just exportedImageBut I didn't

Export complete

All generated file names follow the rules.

Summary

So far, this document describes the functions of SQL Image Viewer

I personally think thisToolsIt is still quite powerful. If there is a cracked version, it will be good for o (release _ release) o

References:

Http://bbs.csdn.net/topics/360172892

Http://www.duote.com/soft/15686.html

Http://www.yohz.com/siv_overview.htm

If anything is wrong, you are welcome to make a brick o