thanks.

Now,DB existing the char,varchar or text,i want to change these to nchar,nvarchar,nvarchar(max) automatic.

however,the sp ,fn too.

And what will be affected in this change is my consideration.

I think the question has been written incorrectly.

select myOrd.Order_No, myiT.Item_No, myOrd.Unique_ID as 'UniqueID'

FROM myOrders myOrd

JOIN myItems myiT

ON myOrd.Order_No = myiT.Order_No

Order BY myiT.Unique_ID desc

select myOrd.Order_No, myiT.Item_No, myOrd.Unique_ID as 'Unique_ID'

FROM myOrders...