|
|
|
|
 |
Copy text or image into or out of SQL Server
|
| Total Hit (7349) |
In this article, I want to show, how you can copy a single text or image value into or out of SQL Server by using the textcopy.exe utility. You can find this utility in the directory containing the standard SQL Server EXE files (C:\Mssql\Binn for SQL Server 6.5, by default and C:\Mssql7\Binn for SQL
....Read More |
Rating
 |
|
|
|
|
|
|
|
|
|
Search/Replace text in text, ntext datatype column
|
| Total Hit (3118) |
In SQL Server anything text longer than 8000 characters can be stored in TEXT or NTEXT datatype column but when you use TEXT or NTEXT datatype is not same as regular char, varchar, nchar or nvarchar datatype. You can not use string function like ltrim, rtrim, replace etc... Then how do you search an
....Read More |
Rating
 |
|
|
|
Brief Tutorial on Text, Ntext, and Image
|
| Total Hit (1129) |
Databases are growing in size and complexity, in part because today's hardware and software allow us to store mind-boggling amounts of data—including multimedia and document data. JPG, PNG, MP3, DOC/RTF, HTML, Unicode, and XML data can all be stored as image, text, or ntext in SQL Server databases.
....Read More |
| Rating
|
|
|
|