摘要:
/******************************** 1、建各种临时表 *********************************/ IF OBJECT_ID('tempdb..#TongsEntity') IS NOT NULL DROP TABLE #TongsEntity 阅读全文
摘要:
SELECT ROW_NUMBER() OVER ( ORDER BY Location ) i,* INTO #A FROM [GMSToolManage].dbo.[Location]; DECLARE @count INT; SELECT @count=COUNT(1) FROM #A; DE 阅读全文
摘要:
SET IDENTITY_INSERT [UserRole] ON; SELECT ROW_NUMBER() OVER ( ORDER BY T1.ID ) i,T1.ID INTO #A FROM [GMSAccount].[dbo].[User] AS T1 JOIN [GMSToolManag 阅读全文
摘要:
--SET IDENTITY_INSERT [User] on; SELECT ROW_NUMBER() OVER ( ORDER BY EmpID ) i,* INTO #A FROM [GMSToolManage].dbo.[employees]; DECLARE @count INT; SEL 阅读全文
摘要:
#include<bits/stdc++.h> using namespace std; #define mp(a,b) make_pair(a,b) const int N=1e4+10; int T,n; int vis[8*N]; map<pair<int,int>,int> myMap; s 阅读全文
摘要:
约瑟夫环问题,问最后一个剩下的是谁。由于末位是4也要淘汰,所以只可模拟得到结果 #include<bits/stdc++.h> using namespace std; const int N = 1005; const int INF=0x3f3f3f3f; int a[N]; int main( 阅读全文