SQLSERVER图片查看工具SQL Image Viewer5.5.0.156
SQLSERVER 图片 查看 工具 SQL Image Viewer5.5.0.156 在2013年某一次北京SQL PASS会议中，格瑞趋势的王中涛大侠就介绍了一款数据库 图片 查看 工具 不知道大家有没有印象 不过这篇文章介绍的插件不是集成到SSMS当中的 这个 工具 的下载地址：http://www.kua
SQLSERVER图片查看工具SQL Image Viewer5.5.0.156
在2013年某一次北京SQL PASS会议中，格瑞趋势的王中涛大侠就介绍了一款数据库图片查看工具
不知道大家有没有印象
不过这篇文章介绍的插件不是集成到SSMS当中的
这个工具的下载地址：http://www.kuaipan.cn/file/id_4401224786927352.htm
大家也可以到官网去下载：http://www.yohz.com/siv_overview.htm
官网介绍得很牛X，可以查看，导出存储在数据库中的图片和文件，而且这个工具的客户包括三星，西门子和索尼
找遍整个互联网，没有找到破解版，有点可惜
最新的版本是5.5.0.156（2013/9/12）可以看到这个软件还在不断更新，最新版本可以支持SQLSERVER2012
使用感受
软件支持多种数据库，不单只是SQLSERVER，比较厉害
数据库驱动可以选择MDAC或者是SQL Native Client
我选择SQL Native Client，数据库选择的是AdventureWorks，AdventureWorks数据库有些表有二进制数据类型的图片列
也有二进制数据类型的文件列，比如word文档，正好可以测试一下这个软件的功能
连接成功之后，在界面的右手边可以看到整个数据库里包含有二进制的数据表都已经全部列出来了，右下角是SQLSERVER2012版本SP1
在SSMS里打开表定义
我们编写SQL语句，然后执行
结果窗口分上下两个
上面的窗口显示图片，下面的窗口显示数据行
细心的朋友会发现，在图片窗口里会显示整个数据行的所有图片列，因为表中只有两行是图片列，所以只显示两列图片
选中那个图片还会显示图片的属性，下面的图片属性显示该图片是GIF图片，长：240，宽：149，大小：20KB
选中图片，然后按右键，会弹出右键菜单
我们可以点击“save item”单独保存这张图片
如果你想切换数据库可以使用下拉列表切换到其他的数据库
要更变图片显示的样式可以使用下拉列表选择，软件支持3种样式
软件的设置菜单也比较简单
导出功能
导出功能可以算是这个软件比较强大的功能了，他可以导出表中的所有图片或者所有文件
例如下面是导出表中的图片
点击“导出”按钮
选择数据源，你可以重新编写SQL，也可以使用刚才的结果集，因为刚才有3行记录，每行记录有两张图片，所以总共6张图片，6个items
你可以选择要导出的文件类型，包括：图片，word文档，excel，ppt等等
可以对导出的图片进行一定特效处理再导出
选择保存导出文件的路径和图片的规则名
文件规则
点击完成，开始导出
由于是试用版，只支持5个items，这里一个item一张图片，即5张图片
文件名按照规则生成
文件功能
我们查询一下[Production].[Document]表
得出的结果
双击其中一个word文档，软件就会马上调用电脑里的word软件office2010打开他
导出表中的word文档
步骤跟刚才一样，只不过在第二步选择导出的文件类型的时候需要勾选Word files
至于特效就不做任何处理了，原样输出，估计这里的特效处理是处理word文档里面的图片
点击“完成”按钮，开始导出
试用版的警告，刚才导出图片的时候也出现的，不过我没有截图
导出完成
生成的文件名都按照规则来进行命名
总结
至此，这篇流水账式的介绍SQL Image Viewer软件功能的文章完成了
个人感觉这个工具还是挺强大的，如果有破解版就好了o(∩_∩)o
参考文章：
http://bbs.csdn.net/topics/360172892
http://www.duote.com/soft/15686.html
http://www.yohz.com/siv_overview.htm
如有不对的地方，欢迎大家拍砖o(∩_∩)o
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to use the chrono library in C?
Apr 28, 2025 pm 10:18 PM
Using the chrono library in C can allow you to control time and time intervals more accurately. Let's explore the charm of this library. C's chrono library is part of the standard library, which provides a modern way to deal with time and time intervals. For programmers who have suffered from time.h and ctime, chrono is undoubtedly a boon. It not only improves the readability and maintainability of the code, but also provides higher accuracy and flexibility. Let's start with the basics. The chrono library mainly includes the following key components: std::chrono::system_clock: represents the system clock, used to obtain the current time. std::chron
How to measure thread performance in C?
Apr 28, 2025 pm 10:21 PM
Measuring thread performance in C can use the timing tools, performance analysis tools, and custom timers in the standard library. 1. Use the library to measure execution time. 2. Use gprof for performance analysis. The steps include adding the -pg option during compilation, running the program to generate a gmon.out file, and generating a performance report. 3. Use Valgrind's Callgrind module to perform more detailed analysis. The steps include running the program to generate the callgrind.out file and viewing the results using kcachegrind. 4. Custom timers can flexibly measure the execution time of a specific code segment. These methods help to fully understand thread performance and optimize code.
How to use string streams in C?
Apr 28, 2025 pm 09:12 PM
The main steps and precautions for using string streams in C are as follows: 1. Create an output string stream and convert data, such as converting integers into strings. 2. Apply to serialization of complex data structures, such as converting vector into strings. 3. Pay attention to performance issues and avoid frequent use of string streams when processing large amounts of data. You can consider using the append method of std::string. 4. Pay attention to memory management and avoid frequent creation and destruction of string stream objects. You can reuse or use std::stringstream.
How to optimize code
Apr 28, 2025 pm 10:27 PM
C code optimization can be achieved through the following strategies: 1. Manually manage memory for optimization use; 2. Write code that complies with compiler optimization rules; 3. Select appropriate algorithms and data structures; 4. Use inline functions to reduce call overhead; 5. Apply template metaprogramming to optimize at compile time; 6. Avoid unnecessary copying, use moving semantics and reference parameters; 7. Use const correctly to help compiler optimization; 8. Select appropriate data structures, such as std::vector.
What is static analysis in C?
Apr 28, 2025 pm 09:09 PM
The application of static analysis in C mainly includes discovering memory management problems, checking code logic errors, and improving code security. 1) Static analysis can identify problems such as memory leaks, double releases, and uninitialized pointers. 2) It can detect unused variables, dead code and logical contradictions. 3) Static analysis tools such as Coverity can detect buffer overflow, integer overflow and unsafe API calls to improve code security.
What is real-time operating system programming in C?
Apr 28, 2025 pm 10:15 PM
C performs well in real-time operating system (RTOS) programming, providing efficient execution efficiency and precise time management. 1) C Meet the needs of RTOS through direct operation of hardware resources and efficient memory management. 2) Using object-oriented features, C can design a flexible task scheduling system. 3) C supports efficient interrupt processing, but dynamic memory allocation and exception processing must be avoided to ensure real-time. 4) Template programming and inline functions help in performance optimization. 5) In practical applications, C can be used to implement an efficient logging system.
How to implement loosely coupled design in C?
Apr 28, 2025 pm 09:42 PM
To implement loose coupling design in C, you can use the following methods: 1. Use interfaces, such as defining the Logger interface and implementing FileLogger and ConsoleLogger; 2. Dependency injection, such as the DataAccess class receives Database pointers through the constructor; 3. Observer mode, such as the Subject class notifies ConcreteObserver and AnotherObserver. Through these technologies, dependencies between modules can be reduced and code maintainability and flexibility can be improved.
How to understand DMA operations in C?
Apr 28, 2025 pm 10:09 PM
DMA in C refers to DirectMemoryAccess, a direct memory access technology, allowing hardware devices to directly transmit data to memory without CPU intervention. 1) DMA operation is highly dependent on hardware devices and drivers, and the implementation method varies from system to system. 2) Direct access to memory may bring security risks, and the correctness and security of the code must be ensured. 3) DMA can improve performance, but improper use may lead to degradation of system performance. Through practice and learning, we can master the skills of using DMA and maximize its effectiveness in scenarios such as high-speed data transmission and real-time signal processing.
