int转换为varchar convert(varchar,@@old) varchar转换为int convert(int,@@old) 比如: UPDATE [dbo].[信息表] SET [价] = convert(int,[价])-100