August 19, 2010 at 3:24 am
Hi,
I am running the same SQL select query in 1 SQL server and gets output of 1 row (e.g: abcd " efg)
In another SQL server which is refrshed from the first one, the same select output is:
abcd
" efg
2 lines instead of one.
Does anybody have an idea?
Thanks,
Ran.
August 19, 2010 at 3:31 am
what are your select query and output format
----------
Ashish
August 19, 2010 at 3:32 am
Before posting any question please provide the details of the table and data and then the query. Just specifying that query is running differently will not help us in finding the solution.
Thanks,
Amit kulkarni
August 19, 2010 at 3:34 am
OK, thanks and sorry.
Query:
Select description from table1 where id = 9992
August 19, 2010 at 3:36 am
and can you please check in both server, query output option is selected to same format.
Either to grid or to text
----------
Ashish
August 19, 2010 at 3:54 am
In both the result is the same... I tried both (grid and text).
August 19, 2010 at 4:02 am
if the values in tables stored in similar way in both the server then its definately some setting which is changing he view.
Which sql version you using??
----------
Ashish
August 19, 2010 at 4:07 am
Same SQL 2005 server with the same product version.
August 19, 2010 at 12:46 pm
Check the ANSI server settings
edit: This is weird and I think there's some missing info. Can you post a screenshot of both results please?
August 20, 2010 at 3:13 am
Hi, thanks.
Do you know which ANSI can be related to? how can I know what are the settings defined on each server?
Thanks,
Ran.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply