W wjlsnet Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-05 #1 在Sql Server 2000中,如何将整形转化为字符串? 字符串又如何转化为整形? 哪儿有函数手册? 谢谢
W wjlsnet Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-05 #3 convert(char(4),id) 这样好像不对呀:)
W wjlsnet Unregistered / Unconfirmed GUEST, unregistred user! 2002-11-05 #6 用这个做好了 update reguser set userid=convert(char(8),(id+10000)) 放大char,加括号(id+10000) 谢谢