Geeks With Blogs

News


Rodney Vinyard - .NET & SQL Developer When all is said and done, more will be said than done February 2007 Entries
how to copy text data from one column to another
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

Copyright © Rodney Vinyard | Powered by: GeeksWithBlogs.net