 |
|
SQL Server Tips by Burleson |
Dependency Walker (Depends.exe)
This tool checks a Windows module and builds a hierarchical tree
diagram of all dependent modules. It lists all the functions
exported by each module and which of those functions are being
called by other modules. This is useful for knowing whether a DLL is
calling Unicode functions from another DLL. You can download Depends
from http://www.dependencywalker.com/.
xp_cap6, ASCII/Unicode Input and Output parameters
This new XP, has the same functionality as xp_cap1. It will read a
string as input and return that string in lower case with the
exception of the first characters of each word, which will be in
upper case. While xp_cap1 only accepted ASCII input and output, this
new XP will accept both ASCII and Unicode and convert between them
when the input and output have different character sets.
The above book excerpt is from:
Super SQL
Server Systems
Turbocharge Database Performance with C++ External Procedures
ISBN:
0-9761573-2-2
Joseph Gama, P. J. Naughter
http://www.rampant-books.com/book_2005_2_sql_server_external_procedures.htm |
