Text field always listed last - SQL Server Forums

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 field always listed last

Author

Topic

Zim327
Yak Posting Veteran

62 Posts

Posted - 2005-03-11 : 14:50:13

Hi,
when selecting data (from ASP or C++) I read that the text field (or a blob) must always be listed last in order for the transaction to work.

Is this true for inserting and updating too?

Best regards,
Zim
(Future Yak God Emperor)

Zim327
Yak Posting Veteran

62 Posts

Posted - 2005-03-11 : 15:53:38

FYI
I can't seem to find the article that I read long ago about the text field going last
BUT
no matter, I inherited a web page that fails intermittenly once the amount of text inserted exceeded approximately 100K.
So I put the text field last in the update and the insert statements and it seems to be working fine.

Inheriting a poorly designed web site isn't as much fun as you would think...

I hope this helps,

Best regards,
Zim
(Future Yak God Emperor)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources