Query the random value of if (object_id (tempdb .. # cc, U) isnotnull) droptable # ccgodeclare @ aintset @ a0while @ a15beginif @ a0selectfloor (rand () * 3) + 3 asccinto # ccelseinsertinto # ccvalues (floor (rand () * 3) + 3) set @ a + 1endselect *
Query the random value of if (object_id ('tempdb .. # cc ', 'U') is not null) drop table # cc go declare @ a int set @ a = 0 while @ a15 begin if @ a = 0 select floor (rand () * 3) + 3 as cc into # cc else insert into # cc values (floor (rand () * 3) + 3) set @ a = @ a + 1 end select *
Query random values in each row
If (object_id ('tempdb .. # CC', 'U') is not null)
Drop table # cc
Go
Declare @ a int
Set @ a = 0
While @ a <15
Begin
If @ a = 0
Select floor (rand () * 3) + 3 as cc into # cc
Else
Insert into # cc values (floor (rand () * 3) + 3)
Set @ a = @ a + 1
End
Select * from # cc
Connection Query
Select a. Class_Content, * from T1103.dbo. T101_1
Inner join (SELECT Class_Code, Class_Content FROM WssMng_SXZ.dbo.ClassTable
WHERE (Fk_ClassName = 'case source') as a on a. Class_Code = T101_1.M101_1_111
Where unitID = '000000'
, Hong Kong Server rental, US space, Hong Kong server