批量生成Insert脚本 SELECT 'INSERT INTO Previse(PreviseID,PreviseDate,PreviseInfo) VALUES('+cast(PreviseID as varchar(10))+',''' + CONVERT(varchar(19), PreviseDate, 121) + ''',''' + PreviseInfo + ''')' FROM Previse WHERE PreviseID > 100