Hypnotizing Your Users: Drawing Spirals In SQL Server

Slava Murygin shows how to draw spirals in SQL Server using spatial data types:

In this script you can play with total number of iterations (@i), with increment value of @R or with width of a line (STBuffer), but generally, you will have always the same “Archimedean” type of a spiral.

Slava shows us how to build a half-dozen different types of spirals, providing sample code for each.

Related Posts

Spheres In SQL Server

Slava Murygin continues his quest to build a graphics engine with spatial data: Couple of years ago I came up with an algorithm of drawing an ellipse using SQL Server spatial geometry: http://slavasql.blogspot.com/2015/02/drawing-ellipse-in-ssms.html I’ve used that algorithm to make a sphere and as in my previous blog of drawing 3D Cube I use external procedure to simplify the […]

Read More

Drawing Cubes With SQL Server Spatial

Slava Murygin has entered his cubism phase: Hey, there is a time to go level up and instead of drawing Spirals, Fractals and other cool stuff I decided to go 3D! So, the first my try will be drawing 3D cubes. As you know, SQL is not an Object Orienting Programming language, and I can’t […]

Read More

Categories

August 2017
MTWTFSS
« Jul Sep »
 123456
78910111213
14151617181920
21222324252627
28293031