Limitation of having column text column

Limitation of having column text column

Post by UmVjd » Thu, 28 Oct 2004 20:35:05


Hi,

I am having table with text column which holds table creation scripts whose
lenght exceeding 8000 charactres..Is there is anyway i can take this value
one by one and execute it dynamically in another db..

Logig should be as follows..

cursor for select text from table

for each value

exec 'text value'

end

deallocate cursor..

Regards
rect
 
 
 

Limitation of having column text column

Post by Wayne Snyd » Thu, 28 Oct 2004 20:56:53

Yes, you can pull off pieces of a text field using the TextPTR function...
Search for this in Books on line and there are some examples...

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, C *** te, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org



whose