Sunday, February 12, 2012

Are there any difference in 7 and 2000 regarding set ansi_padding?

Are there any difference between SQL Server 7 and SQL Server 2000 regarding
the set ansi_padding?
I have the following script:
set ansi_padding on
declare @.x integer
select @.x = 1
select case when @.x = 1 then 'test ' else 'test2 ' end + 'result'
Running the script in SQL Server 2000 will get this:
test result
Running the script in SQL Server 7 will get this:
testresult
Why are the results be different?no difference that I'm aware of, checkout KB articles:
INF: Behavior of ANSI_PADDING - ID: 154886
INF: Insertion of Strings Containing Trailing Spaces - ID: 231830
Are you running this from the same client machine and same application? If
not - try the same test from the same test box and from the same client
application.
additional references:
PRB: ALTER COLUMN Sets TrimTrailingBlanks Property to NO - ID: 296559
Fany Vargas
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

No comments:

Post a Comment