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.
| Author |
Topic |
|
sqldba20
Posting Yak Master
183 Posts |
 Posted - 2007-09-11 : 16:55:19
|
| I understand the Limit 'Bytes per string column' for SQL 2000 is 8000. Any Idea whether it is the same for VIEWS? Is there a Limit?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-11 : 16:59:02
|
| Well you could always just use text if you need to go beyond the limitation. SQL 2005 provides the varchar(max) data type.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2007-09-11 : 17:00:02
|
| So Is there a limitation of 8000 on views too? |
|
|
|
sqldba20
Posting Yak Master
183 Posts |
Posted - 2007-09-11 : 17:04:30
|
| Sorry.... What I meant is... the Bytes per row limit is 8060 and whether that will apply also for views?Thanks ! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-11 : 17:18:25
|
| What exactly are you trying to do in a view?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-11 : 17:37:54
|
| try it out--------------------keeping it simple... |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-12 : 23:39:06
|
| Limited by number of columns per select statement. |
|
|
|
|
|
|
Views