datetime century date into pad dynamic cursor money percent sp job isnumeric isdate over update
SQLUSA.com
SQL 2008 GRAND SLAM ON 49 CD
FREE TRIAL  CLICK HERE TO ORDER  SEARCH
SQL Server Training SQL 2005 Scripts SQL 2008 Articles
SQL JOBS News Format Developer
How to use READTEXT for text reading?

Execute the following SQL Server T-SQL example scripts in SSMS Query Editor demonstrate the reading segments of a text string.

-- SQL Server readtext - SQL Server textptr

USE pubs;

DECLARE  @p VARBINARY(16) -- pointer to text

 

SELECT @p = TEXTPTR(pr_info)

FROM   pub_info pr

       INNER JOIN publishers p

         ON pr.pub_id = p.pub_id

WHERE  p.pub_name = 'Five Lakes Publishing'

 

READTEXT pub_info.pr_info @p 0 256;

/*

pr_info

This is sample text data for Five Lakes Publishing, publisher 1622 in the

pubs database. Five Lakes Publishing is located in Chicago, Illinois.   

This is sample text data for Five Lakes Publishing, publisher 1622

in the pubs database. Five Lakes Publishin

*/

 

-- Reading 4 bytes at a time starting with offset 120

READTEXT pub_info.pr_info @p 120 4;

/*

pr_info

d in

*/

 

READTEXT pub_info.pr_info @p 124 4;

/*

pr_info

 Chi

*/

 

READTEXT pub_info.pr_info @p 128 4;

/*

pr_info

cago

*/

 

READTEXT pub_info.pr_info @p 132 4;

/*

pr_info

, Il

*/

 

READTEXT pub_info.pr_info @p 136 4;

/*

pr_info

lino

*/

 


Order SQL 2008 GRAND SLAM Today!
SQLUSA.com Home Page
SQL Server Training at www.sqlusa.com.
Microsoft SQL Server 2012 Training Videos at www.sqlusa.com.
SQL Server 2008 Video Training at www.sqlusa.com.
SQL Server 2005 Training Videos at www.sqlusa.com.
Accounting
Administrative
Advertising
Arts
Architecture
Banking
Business Intelligence
Career Jobs
Celebrity
Computer
Consulting
Customer Service
Education
Engineering
Entertainment
Entry Level
Executive
Federal
Finance
Government
Hardware
Healthcare
Hospital
Human Resources
Information Technology
Insurance
Internet
Job Openings
Laboratory
Law Enforcement
Legal
Logistics
Manufacturing
Marketing
Medical
Military
Nursing
Pharmaceutical
Physician
Public Relations
Publishing
Real Estate
Restaurant
Retail
Sales
Social Media
Software
SQL Database
Telecomm
Therapist
Training
Transportation
Truck Driver
Travel
Web
Work from Home

FREE SS SQL / BI OLAP Short Videos on YOUTUBE.com

Microsoft Community Contributor 2011 Microsoft Community Contributor 2012

Search SQLUSA FREE SQL Server Articles & FREE T-SQL Scripts

JOIN US ON TWITTER

Copyright 2005-2012, SMI Corp. All Rights Reserved.

SQL Server 2012 is a program product of Microsoft Corporation.
SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.