摘要： --一个字符串abc_dcdds_ds_dsggg，需要按下划线将其截取成四段 declare @col varchar(30) set @col='abc_dcdds_ds_dsggg' set @col=replace(@col,'_','.')select parsename(@col,4), parsename(@col,3), parsename(@col,2), parsename(@col,1) /*parsename ('object_name',object_piece )'object_name' 阅读全文