Hi, im pretty new to SQL and i?ve run into a problem
I?m running a MSSQL 2005 database and i have a table with a column that contains bit values (0 or 1), now i want to copy all the data in that column to a new column in the same table with the datatype nchar(1) with the values 'Y' corresponding to the 1:s and 'N' for the 0:s.
Is there a query that does this or can i do some changescript in Management studio?
Question
KiwiSwe
Hi, im pretty new to SQL and i?ve run into a problem
I?m running a MSSQL 2005 database and i have a table with a column that contains bit values (0 or 1), now i want to copy all the data in that column to a new column in the same table with the datatype nchar(1) with the values 'Y' corresponding to the 1:s and 'N' for the 0:s.
Is there a query that does this or can i do some changescript in Management studio?
I?ve Googled for hours but found nothi:( :(
Link to comment
Share on other sites
1 answer to this question
Recommended Posts