摘要:
ALTER view [dbo].[view_weiswysjl]asselect distinct m.dbid,m.baogbh,m.chanpmc,m.jianymdyq,m.weitrq,(','+s.jjy+',') as jjy from mainexam m inner join (s... 阅读全文
摘要:
sql 没有split函数,所以要自定义一个create function f_split(@c varchar(2000),@split varchar(2)) returns @t table(col varchar(20)) as begin while(charindex(@split... 阅读全文