Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Text datatype

Author  Topic 

anandmaran
Starting Member

1 Post

Posted - 2005-02-23 : 05:11:38
How do i retrieve a value of datatype text using query analyzer or enterprise manager

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-23 : 06:13:00
emmm.... like this?

declare @b table (name text)
insert into @b
select replicate('b', 16000) union all
select 'aoegfsegea'

select * from @b


Go with the flow & have fun! Else fight the flow
Go to Top of Page
   

- Advertisement -