将其他数据类型 转换成字符类型

   string SQL =
 "SELECT distinct projectid,projectname,p.versionid,d.VersionName,isrecommend,industrytype,createdate,usecounter,creater,createdate,cast(p.Remark as varchar(200)) as Remark FROM T_ProjectInfo p,T_DataVersion d {0} ORDER BY projectid DESC ";
posted @ 2009-09-23 15:54  书奎  阅读(218)  评论(0编辑  收藏  举报