随笔分类 -  sql server

摘要：修改sql sever数据库文件路径: ALTER DATABASE [数据库]MODIFY FILE( NAME = 'idx_02', --文件名称 FILENAME = N'G:\db\idx_02.ndf' --新的物理路径);GO 阅读全文

摘要：STUnion 方法 例： DECLARE @D geometry select @D=geomCol from table1 WHERE id=1 select geomCol .STUnion(@D) from table1 WHERE id=2 阅读全文

摘要：select geometry::STGeomFromText('POINT('+ CAST(CAST(c_abs_x AS DECIMAL(36, 12)) AS VARCHAR(50)) +' '+CAST(CAST(c_abs_y AS DECIMAL(36, 12)) AS VARCHAR( 阅读全文