Not able to see the whole data

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

General SQL Server Forums

New to SQL Server Programming

Not able to see the whole data

Author

Topic

kmsalih
Starting Member

4 Posts

Posted - 2006-06-28 : 02:27:10

hi gurus,

I am very new to sql server db.

My issue is i created one table


create table a 
(
a varchar(8000)
)

Also inserted some values which has a length of 5000.

if i issue the select command i am not able to view the full data.

Can u please guide me

SALIH KM

shallu1_gupta
Constraint Violating Yak Guru

394 Posts

Posted - 2006-06-28 : 02:30:34

Hi,
This is because of setting maximum characters per Column. you can change the default setting to 8000. Go to Query analyser--> tools-->options-->Results-->maximum characters per column reset it

kmsalih
Starting Member

4 Posts

Posted - 2006-06-28 : 02:42:29

Thanks shallu for your quick guidance.

SALIH KM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources