ALTER Datatype of Column - SQL

[NewsBot]

I'm using SQL server 2000.

Can anyone provide me an alter script for changing the datatype of column from nvarchar(200) to binary(100) which allows NULL.

 

ALTER TABLE t1

ALTER COLUMN binary(100) NULL

 

but this throws an error "Disallowed implicit conversion from data type nvarchar to data type binary". I even tried using convert function but it didn't wrk, help me out.....

 

More...

 

View All Our Microsoft Related Feeds