why this different?
Posted on 2013-02-07
I have two MS SQL database. They are the same database. but made in different time ( 6 ms ago) and different version of MS SQL server. One is made MS SQL 2008, another one is maded in MS SQL 2008 R2
When I compare them, I see the following is strange.
One database showing the following for table ABC
[name] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
Another database showing the same table and same field as
[NAME] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
Why NOT NULL becomes NULL???