--==testdata==                 --======徐王锦======                --==2009/01/15/pm 23:19====            --======关于查询语句的顺序======--test dataif object_id(Ncompany,U) is not nulldrop

 关于 分组每次取随机 top 记录(csdn 看见问题 心血来潮)if object_id(tempdb..#,U)is not null drop table #gocreate table #(chapterid int, chapter varchar(10)) insert # select   1   ,           a insert # select    1 ,

 SQL code <!--Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->--个人blog http://blog.youkuaiyun.com/wlzd3636/--------

dad(0d)da(da)da()ssxxxxx(2弄)(3路)xxx()xxx去掉()内的字符--2005select * into ## from(select sring=xxxxx(2弄)(3路)xxx()xxx union all select dad(0d)da(da)da()ss)x--cte+nums 解决with xwjas(select id=1 union