04 2020 档案
摘要：select (t.shape.STAsText()) as shape,t.id from geotest t order by 1 offset 0 rows fetch next 10 rows only INSERT INTO geotest(shape) VALUES (geometry:
阅读全文
摘要：select st_astext(line) from geotest; INSERT INTO geotest (line) VALUES(GeomFromText('LINESTRING(0 0,1 1,2 2,3 3)')); SET @g2 = 'POLYGON((0 0,3 0,3 3,0
阅读全文
摘要：在SQLServer中执行递归的时候出现错误 #子查父递归With Tree As( SELECT id, parent_id FROM dbo.data_catalog C UNION ALL SELECT P.id, P.parent_id FROM dbo.data_catalog P, Tr
阅读全文
摘要：# 修改字段名称为临时字段 exec sp_rename 'data_config.description', description1,'COLUMN'; # 创建新的字段并设置为目标格式alter table data_config add description text ;# 把临时字段中的
阅读全文
摘要：mount -t tmpfs -o size=40G tmpfs /home/arcgis/server/framework/runtime/spark/work
阅读全文
