Geeks With Blogs

News


Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done

how to copy text data from one column to another

EXEC sp_dboption 'database name', 'select into/bulkcopy', 'true'

GO

DECLARE @textData varchar(8000)

select @textData = textData from table where id = 5

print '@textData'

print @textData

DECLARE @ptrvalDest binary(16)

SELECT @ptrvalDest = TEXTPTR(xsl)

FROM table WHERE id = 6

WRITETEXT table.textData @ptrvalDest @textData

GO

EXEC sp_dboption 'database name', 'select into/bulkcopy', 'false'

GO

Posted on Wednesday, February 21, 2007 1:51 PM SQL Server 2000 Tricks | Back to top


Comments on this post: how to copy text data from one column to another

# re: how to copy text data from one column to another
Requesting Gravatar...
Now writing my own essay on it, and your post is a real helping hand to me. Thank you very much, very informative and comprehensive. You saved me a lot of time.
Left by term paper on Jun 22, 2010 1:39 AM

Your comment:
 (will show your gravatar)


Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net