IF OBJECT_ID('PascalTriangle') IS NOT NULL
DROP FUNCTION PascalTriangle
GO
CREATE FUNCTION PascalTriangle
(
@x INT, @y INT
)
RETURNS INT
AS
BEGIN
if(@y=1 OR @y=@x)
return 1
return dbo.PascalTriangle(@x-1,@y-1) + dbo.PascalTriangle(@x-1,@y)
END
GO
DECLARE @i INT, @j INT , @str VARCHAR(200)
SELECT @i =1
WHILE(@i <= 10)
BEGIN
SELECT @j = 1, @str =''
WHILE(@j<=@i)
BEGIN
SET @str = @str + LEFT(CONVERT(VARCHAR(200), dbo.PascalTriangle(@i,@j))+SPACE(10),7)
SET @j=@j+1
END
PRINT @str
SET @i=@i+1
END