NewsBot
1
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
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