|
|
|
|
 Click here to copy the following block | declare @vc1 varchar(255), @vc2 varchar(255), @vc3 varchar(255), @count int,
@textptr varbinary(16), @len int, @trunclen int
select pr_info into #t from pubs..pub_info where pub_id = '0736'
select @count = 1, @textptr = TEXTPTR(pr_info), @len = DATALENGTH(pr_info) from #t
while (@len > 0)
begin
if @count = 1 select @vc1 = convert(varchar(255), pr_info) from #t
if @count = 2 select @vc2 = convert(varchar(255), pr_info) from #t
if @count = 3 select @vc3 = convert(varchar(255), pr_info) from #t
if @len < 255 select @trunclen = @len else select @trunclen = 255
updatetext #t.pr_info @textptr 0 @trunclen NULL
select @count = @count + 1, @len = @len - @trunclen
end
select @vc1, @vc2, @vc3 |
|
|
|
|
|
|
Submitted By :
Nayan Patel
(Member Since : 5/26/2004 12:23:06 PM)
|
 |
|
|
Job Description :
He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting. |
|
View all (893) submissions by this author
(Birth Date : 7/14/1981 ) |
|
|