摘要： insert into PE_U_Recommend(ID,GuestName,GuestEmail,Mobile,Area,BuyType,GouMuDi,JutiQuwei,Yusuan,QiwanArea,Huxing,Beizhu,AdminReply)select tabletest2.GeneralID,tabletest.name ,--留言人tabletest.email,--邮箱tabletest.mobile,--电话tabletest.region,--地区 tabletest.[type],--类型tabletest.[description],--目标 个人居住 投. 阅读全文

摘要： create table textvalue (IDtext ntext)godeclare @cunt intset @cunt=1while @cunt <200 begin insert into textvalue values(CAST(@cunt*1000.111111 as varchar(max))) endgoselect * from textvaluego/*select replace(cast(IDtext as varchar(100)),'.','+') from textvalue where IDtext like  阅读全文