SQL SERVER??????????
?????ok_008 ???????[ 2017/2/27 10:46:43 ] ????????????? SQL Server
?????????
??????testing?У???????orders???и??????????dba???????????????????????????????orders??
????????
???????????????????????orders???????????????е????????
????sql?У????cross join ?????????table (?? A ??B )?????γ????????????????1
?????1
????????????1???????????????ε???????????????????16?е????????2??
????
?2
??????sql sever ?У?????????sql?????????A?? B??????????????ο???????????????е?????
use tempdb
go
declare @x bigint =2
declare @i int=1
while(1=1)
begin
set @x=square(@x)
if @@ERROR<>0 break;
print rtrim(@i)+' : '+rtrim(sqrt(@x))+' x '+rtrim(sqrt(@x))+' = '+rtrim(@x);
set @i+=1;
end
??????????????A??B?????????????5?ο???????????????????
????????
????SQL SERVER ????
;With
a0 As(Select id=1 Union All Select id=1)??
a1 As(Select a.id From a0 a??a0 b)??
a2 As(Select a.id From a1 a??a1 b)??
a3 As(Select a.id From a2 a??a2 b)??
a4 As(Select a.id From a3 a??a3 b)??
t As(Select id=Row_number() Over(Order By a.id) From a4 a??a4 b)
select top 1000000 id from t
???????????????????????У??????????????????????????????????????????????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11