Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abhijeetdighe
Starting Member
24 Posts |
 Posted - 2009-12-18 : 05:22:09
|
| HiI have table with ntext column.In that column I was storing data,without using N prefix in insert query.But now I want to update all data in this column, so that it will look like if I had used N-prefix.For inserting new record with N-prefix I use:insert into myTab(myCol) values (N'test')Like above how can I update old records with N-prefix?What will be the update query to update 'myCol' with N-prefix? |
|
|
|
|
|
NText column and N-prefix