3.sqlserver導(dǎo)出腳本
select top 20 cast (ring_id as varchar(50)) +'|'+ring_name+'|'+name_length +'|'+
cast (singer_id as varchar(50))+'|'+singer_name+'|'+
cast (special_id as varchar(50))+'|'+ cast (publish_date as varchar(50))+'|'+
play_length+'|'+replace(cast(lyric as varchar(12000)),"
",char(13))+'|'
from ring_lib where ring_id>12777567;