10 2009 档案

一道sql面试题解法
摘要：id strvalue type1 how 12 are 13 you 14 fine 25 thank 26 you 2要求用sql把它们搜索出来成为这样的#how are you#fine thank you#解答：select (select '#'+replace( replace((SELECT strvalue FROM tb_test t where type = 1 FOR XML... 阅读全文
posted @ 2009-10-30 11:18 superstar 阅读(249) 评论(0) 推荐(0)