随笔分类 -  sql

用transact-sql解决一些小问题(一元二次方程的解等)
摘要:--transact-sql编程球50~100之间所有能被3整除的奇数之和declare @count int,@sum intselect @count=51,@sum=0while @count0 print '此一元二次方程有两个解分别为:x1='+cast(@x1 as char(8))... 阅读全文

posted @ 2014-12-23 09:16 彼此珍惜 阅读(758) 评论(0) 推荐(0)

用TRansact-sql 实现 n!
摘要:declare @sum int,@count intselect @sum=0,@count=0label_1:select @count=@count+1select @sum=@sum+@countif @count<=6goto label_1select @count '数值',@sum ... 阅读全文

posted @ 2014-12-22 21:22 彼此珍惜 阅读(126) 评论(0) 推荐(0)