随笔分类 - SQLServer
SQLServer
摘要：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:
阅读全文
摘要：在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 ;# 把临时字段中的
阅读全文
