6.5 /7.0

6.5 /7.0

Post by Roger Nyg?r » Sat, 19 Aug 2000 04:00:00



This statement differ between mssql6.5 and mssql7.0

Select a='test'+NULL

On 6.5 the return is:
a
----
Test

On 7.0 thereturn is:
a
----
NULL

I want sql7.0 to return the same that sql6.5 returns. ist hat possible??

-Roger Nyg?rd

 JOBAK-Data as

 
 
 

6.5 /7.0

Post by Allan Mitchel » Sat, 19 Aug 2000 04:00:00


SET CONCAT_NULL_YIELDS_NULL OFF

ALLAN


Quote:> This statement differ between mssql6.5 and mssql7.0

> Select a='test'+NULL

> On 6.5 the return is:
> a
> ----
> Test

> On 7.0 thereturn is:
> a
> ----
> NULL

> I want sql7.0 to return the same that sql6.5 returns. ist hat possible??

> -Roger Nyg?rd

>  JOBAK-Data as


 
 
 

1. Cursor Behaviour in 6.5/7.0

Hello All,
Greetings...
Please create the Stored Proc below in 6.5 and 7.0 in the PUBS Database
and see the Result Sets. I found the problem when was migrating one of
the stored procs in our 6.5 DB.
***********STORED PROC BEGIN **********************
drop proc nkcurTest
go
create proc nkcurTest
as




print "****SELECT VARIABLE assigned before DECALRE CURSOR****"

declare curtest cursor for
select au_id , au_lname from authors

open curtest


begin


end
close curtest
deallocate curtest

print ""
print "****SELECT VARIABLE assigned after DECALRE CURSOR before, OPEN
CURSOR****"
declare curtest1 cursor for
select au_id , au_lname from authors


open curtest1


begin


end
close curtest1
deallocate curtest1
go
***********STORED PROC END **********************
I would like to know if any of u have a similar problem and the
possible resolution to this. IS it a BUG or is this how works in SQL
7.0???
Any thoughts would be helpful.
Thanks
NK

Sent via Deja.com http://www.deja.com/
Before you buy.

2. SQL client connection

3. Transferring Data and Database Objects between 2 SQL 6.5/7.0 servers

4. mvbase & Piclan-ip - current opinion

5. Implementing Large DB on SQL Server 6.5/7.0

6. sort: bob write not complete after 10 seconds

7. Upgrade 6.5 - 7.0 --Realistic New Server Specs?

8. Transfer 6.5 7.0

9. SQL 6.5 / 7.0 Server Switch - happens without user?

10. migrate Sybase 11.0.1 and Sybase 11.5.1 to MS sql 6.5/7.0

11. Converting from Oracle 7 to SQL Server 6.5/7.0

12. Upgrade 6.5 - 7.0 Error 99!!!