July 3, 2008 at 1:44 am
Column name : ExecSummary, VARCHAR(8000)
UPDATE dbo.tblRegistration
SET ExecSummary='
extensive experience with IE,HTML & MS Office(Word,Excel,Powerpoint,Publisher) proficient in written, oral & interpersonal communication skills
organized & dedicated with positive attitude
multitasking with or without pressure thrive on working in a challenging
environment can work individually and/or in a group effectively'
WHERE emailaddress='mcloncion@gmail.com'
But it could only show me :
extensive experience with IE,HTML & MS Office(Word,Excel,Powerpoint,Publisher)
proficient in written, oral & interpersonal communication skills
organized & dedicated with positive attitude
multitasking with or without pressure thrive on working in a cha
This content is less than 8000 characters, why it failed ?
July 3, 2008 at 2:14 am
Please don't cross post. It just wastes people's time and fragments replies. many of us read all the forums.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic527823-338-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 7, 2008 at 2:14 am
Hi,
If you are able to execute "Update" statement without getting any error means, then no problem in your query. You have to modify "Maximum characters per column" setting in your query editor.
For SQL Serve 2005
Go to Tools - Options - Query Results - Sql Server - Results to text
Set 8000 for "Maximum number of characters displayed in each column"
For SQL Server 2000
Go to Tools - Options - Result
Set 8000 for "Maximum characters per column"
Now you can run your query, you will get the complete statement which you stored.
I hope this will help you.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply