◎createtabletb3 (idin...... create table tb3 (id int identity(1,1) primary key clustered, l_name varchar(100)) --tb3数据 id l_name ----------- ------------------------------------------------------- 1 gsdg#123 2 fh#3435 3 fghdfgh#67867 4 lkhgvhg#7688796 SELECt id,left(l_name,charindex('#',l_name)-1) l_name } from tb3 union all SELECt id,substring(l_name,charindex('#',l_name)+1,len(l_name)-charindex('#',l_name)+1) l_name from tb3 --显示结果 id l_name ----------- ----------------------------------------------------- 1 gsdg 2 fh 3 fghdfgh 4 lkhgvhg 1 123 2 3435 3 67867 4 7688796 |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-29 17:25 , Processed in 0.228505 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.