能用sql画个圆吗？

Question

比较的难。现在怎么各种要求都想让sql做，看来sql标准得修改了

Answer 1

declare @i int,@r int
select @i=1,@r=40print space(@r)+'*' --天诛
while @i<80
begin
print space(@r-sqrt(2*@r*@i-@i*@i))+'*'+space(2*sqrt(2*@r*@i-@i*@i))+'*'
set @i=@i+1
end
print space(@r)+'*' --地灭/*                                        *
                               *                 *
                           *                        *
                        *                              *
                      *                                  *
                    *                                      *
                  *                                          *
                 *                                             *
                *                                                *
              *                                                  *
             *                                                    *
            *                                                       *
           *                                                         *
          *                                                           *
         *                                                            *
        *                                                              *
        *                                                                *
       *                                                                 *
      *                                                                  *
     *                                                                    *
     *                                                                     *
    *                                                                      *
    *                                                                       *
   *                                                                        *
   *                                                                         *
  *                                                                          *
  *                                                                          *
  *                                                                           *
 *                                                                            *
 *                                                                            *
 *                                                                             *
 *                                                                             *
*                                                                              *
*                                                                              *
*                                                                               *
*                                                                               *
*                                                                               *
*                                                                               *
*                                                                               *
*                                                                               *
*                                                                                *
*                                                                               *
*                                                                               *
*                                                                               *
*                                                                               *
*                                                                               *
*                                                                               *
*                                                                              *
*                                                                              *
 *                                                                             *
 *                                                                             *
 *                                                                            *
 *                                                                            *
  *                                                                           *
  *                                                                          *
  *                                                                          *
   *                                                                         *
   *                                                                        *
    *                                                                       *
    *                                                                      *
     *                                                                     *
     *                                                                    *
      *                                                                  *
       *                                                                 *
        *                                                                *
        *                                                              *
         *                                                            *
          *                                                           *
           *                                                         *
            *                                                       *
             *                                                    *
              *                                                  *
                *                                                *
                 *                                             *
                  *                                          *
                    *                                      *
                      *                                  *
                        *                              *
                           *                        *
                               *                 *
                                        *
*/

Answer 2

调了一下参数。。
如果分辨率是nxn的话，再把半径弄大，效果也许好些。
我把半径弄到1000，csdn说我超长不让发……
declare @i int,@r int
select @i=1,@r=40print space(@r)+'*' --天诛
while @i<80
begin
if(@r>sqrt(2*@r*@i-@i*@i)+4)
print space(floor(@r-sqrt(2*@r*@i-@i*@i)))+'*'+space(2*ceiling(sqrt(2*@r*@i-@i*@i)))+'*'  --生死轮回
set @i=@i+1
end
print space(@r)+'*' --地灭/*                                        *
                               *                  *
                           *                          *
                        *                                *
                      *                                    *
                    *                                        *
                  *                                            *
                 *                                              *
                *                                                *
              *                                                    *
             *                                                      *
            *                                                        *
           *                                                          *
          *                                                            *
         *                                                              *
        *                                                                *
        *                                                                *
       *                                                                  *
      *                                                                    *
     *                                                                      *
     *                                                                      *
    *                                                                        *
    *                                                                        *
    *                                                                        *
    *                                                                        *
     *                                                                      *
     *                                                                      *
      *                                                                    *
       *                                                                  *
        *                                                                *
        *                                                                *
         *                                                              *
          *                                                            *
           *                                                          *
            *                                                        *
             *                                                      *
              *                                                    *
                *                                                *
                 *                                              *
                  *                                            *
                    *                                        *
                      *                                    *
                        *                                *
                           *                          *
                               *                  *
                                        *
*/