摘要:
现实生活中,上级和下级之间可能存在跨级的关系,比如博士生下面是初中生,中间还有高中、大学,那么就把它补充入数据库。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 阅读全文