SQL Programming for Qian Order (SQL Server)

最新推荐文章于 2023-07-01 17:14:51 发布

zhangxiao86

最新推荐文章于 2023-07-01 17:14:51 发布

阅读量285

点赞数

分类专栏： SQL/LINQ 文章标签： sql server sql random insert table 2010

本文链接：https://blog.csdn.net/zhangxiao86/article/details/7250251

版权

SQL/LINQ 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

--Create table Table1(id int,Rndvalue int)


Declare @OrderDetails Table(Orderid int,Price int,discountedPrice int, Discount varchar(20),SaleDate date)

Declare @index int

select @index=1

Declare @random int
select @random = 70

Declare @discounted int
select @discounted = 0

Declare @stringDiscount Varchar(20)
select @stringDiscount = 'Discount 5% '

Declare @nodiscount varchar(20)
select @nodiscount = 'No discount'

while @index<501

Begin

select @random = ceiling(1000*Rand())

if(@random > 70)
Begin
select @discounted = 0.95 * @random
--Insert into @OrderDetails values(@index,@random,@discounted,@stringDiscount,DATEADD(DAY, ABS(CHECKSUM(Rand()) % 3650), '2010-01-01'))
Insert into @OrderDetails values(@index,@random,@discounted,@stringDiscount,cast(
  cast(getdate() as int)
  -365*2*rand(cast(cast(newid() as binary(8)) as int))
as datetime))

end
else
--Insert into @OrderDetails values(@index,@random,@random,@nodiscount,DATEADD(DAY, ABS(CHECKSUM(Rand()) % 3650), '2010-01-01'))
Insert into @OrderDetails values(@index,@random,@random,@nodiscount,cast(
  cast(getdate() as int)
  -365*2*rand(cast(cast(newid() as binary(8)) as int))
as datetime))


Select @index=@index+1

end

Select Orderid,Price,discountedPrice,Discount,SaleDate from @OrderDetails