--try
insert into test1(colum1, colum2, colum3)
select N''+colum1+'',N''+colum2+'',N''+colum3+'' from test2
insert into test1(colum1, colum2, colum3)
select N''+colum1+'',N''+colum2+'',N''+colum3+'' from test2
但 insert tb select ....不知道在哪加N
改成nvarchar试试看?
然后插入的时候加上N'中文'试试看?
select N''+colum1+'',N''+colum2+'',N''+colum3+'' from test2
-----------------------------------
測試通過,剛打錯了insert testn(test,test1,test2) ( select test, N''+test1,N''+test2 from testm)
--------------------------------
也可以
insert testn(test,test1,test2) ( select test, test1,test2 from testm)--------------
我的也可以