August 23, 2004 at 5:47 am
I am in the process of moving from SQL 7 to Sql 2000. I notice in 7 if I say "where [Field] = -1" I get all the records where the value is true. In SQL 2000 I have to use "where [Field] = 1". I can't remember why I started using = -1 but is this a database setting that I can change or is it something that now works differently in SQL 2000.....or I will have to go through 100's of view to change it!!
August 23, 2004 at 6:14 am
See my response for the following message:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=124444
You can use sp_dbcmptlevel to simulate the SQL Server 7 behaviour, but this will prevent you from using SQL Server 2000-specific features (for example: UDF-s, declarative cascading referential integrity, instead-of triggers, indexed computed columns, etc).
Razvan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply