摘要: 现实生活中,上级和下级之间可能存在跨级的关系,比如博士生下面是初中生,中间还有高中、大学,那么就把它补充入数据库。SQLSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER procedure [dbo].[FillOrgLevel] @year int,@quarter intas beginset nocount on--填充之前的操作--delete from [SDM].[dbo].[ocm_QV_VOrg] -- where Year=@year and (Quarter=('Q'+cast(@quarter as ch 阅读全文
posted @ 2012-06-21 13:35 Alvin Yue 阅读(1792) 评论(0) 推荐(0) 编辑