by Jacky Xu

Before a new version of SQL server is released, we always implement data paging through the transact-SQL function “ROW_NUMBER” and it always needs a nested SQL script. Microsoft released new scripts “OFFSET” and “FETCH” for data paging functions. Here are two sample queries for different SQL server version paging function.

First, we query all dat...

by Jacky Xu

Sometimes we have project where we need to connect to an sftp server, download and upload a file. But, Microsoft .net library does not have an easy solution for it. WinSCP provides a .net library to operate the sftp site easily.

1.       You should download the library from WinSCP website and install it.

2.       Add it...

by Jacky Xu
OCR (Optical Character Recognition) is the recognition of printed and written text characters. This functionality is compatible with Microsoft Office and here is how OCR checks your image's file, translates it into text, then saves this information into a text file.

First, install Microsoft Office Document Imaging 2007 on your device. If run Office 2010 or higher, you may install Shar...