Hi,
I have table called : table1 with 200 rows.
I have Column1 as 1st column which is nvarchar and null. I want to change this column to NOT NULL and make that column1 as primary key. But its not allowing me to do that.
I checked that all values are NOT NULL for Column1.
Still,
alter table table1
alter column column1(nvarchar(50),not null ) is not working ?
Any inputs ?
...
Go to the complete details ...