摘要：from dbo.ocm_map_PositionRelation pp left joindbo.[fun_GetAsIsPEPropertyExtent](getdate()) ps on pp.PositionId = ps.PositionID解决方法:You need CROSS or OUTER APPLYYou need to be on SQL Server 2005+And most important, the database compatibility needs to be 90 or higher 阅读全文

摘要：1 --第一步，读取所有视图 2 select identity(int,1,1) flag,[name] names into #tmp 3 from sysobjects where crdate>'2012-07-09' 4 5 -- 执行上一步之后再执行下面： 6 --第二步循环删除 7 declare @tb varchar(1000) ,@a int,@b int,@sql varchar(8000) 8 select @a=min(flag),@b=max(flag) from #tmp 9 while @a<=@b 10 begin ... 阅读全文