我有一个表,其中包含要用来创建新数据库的所需表名、列名、列数据类型和列数据长度。 现在,我正在嵌套一些游标,以打印出每个唯一的表名及其附带的列名。 当我运行下面的代码时,它会永远循环。SET NOCOUNT ON;
SELECT DISTINCT tblNm FETCH NEXT FROM spC2 INTO @curColNm
dat_ftprints is the list of 25 SpatialPolygonsDataFrame
if (b == 1){ spc_intersect_poly2 <- dat_ftprints[[b+1]]
spc_intersect_temp <- raster::intersect(spc_intersect_poly1, <
我有一个数据库函数,当我想要过滤掉字符时,我会使用它,但我不知道如何合并2并使其工作。Here's the splitting code: (SELECT 1 AS spc_loc SELECTspc_loc + 1 from for_tally WHERE spc_loc < 65SELECT spc_loc into #tally from for_tally