Hi guys,
Quick question (I hope).
Why is there a difference in the output of this query in 6.5 campatibility vs 8.0 campatibility?
DECLARE @.FooterLine varchar(30)
select @.FooterLine = rtrim(@.FooterLine) + 'Run by Region'
select @.footerline
6.5 returns Run by Region
8.0 returns NULLbecause something + NULL = NULL in 8.0
if you initialize @.FooterLine to '' or something else you won't have this problem.|||HAHA, thats right. Thanks.
Sunday, February 19, 2012
6.5 vs 8.0 query output. Please shine some light.
Labels:
campatibility,
campatibilitydeclare,
database,
footerline,
guys,
light,
microsoft,
mysql,
oracle,
output,
query,
server,
shine,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment