共 2 篇文章 |
|
fetch next from test_Cursor into @iddeclare @GeoBuilding geographyset @GeoBuilding=(select GeoGraph from MapElement where ID =(select MapElementID from Layer_Base_Building where ID=@id))update Layer_Water_Region set BuildingID=@id where ID in(select ID from Layer_Water_Region where MapElementID in(SELECT TOP 2000 ID ... 阅2819 转15 评0 公众公开 13-02-28 11:39 |
--如果@PageCount为NULL值,则计算总页数(这样设计可以只在第一次计算总页数,以后调用时,把总页数传回给存储过程,避免再次计算总页数,对于不想计算总页数的处理而言,可以给@PageCount赋值)IF @PageCount IS NULLBEGIN SET @sql=N''SELECT @PageCount=COUNT(*)'' +N'' FROM ''+@tbname +N'' ''+... 阅531 转3 评0 公众公开 12-09-03 10:38 |