摘要：
SELECT A.name AS table_name, B.name AS column_name, C.value AS column_description FROM sys.tables A INNER JOIN sys.columns B ON B.object_id = A.object 阅读全文
摘要：
临时表的创建有两种，考虑有时候会对临时表做一些数据处理，create会方便很多 SELECT * INTO #temp1 FROM temp1 IF object_id(N'tempdb..#temp1',N'U') is not null BEGIN DROP TABLE #temp1 END C 阅读全文
摘要：
CREATE INDEX IX_table_nStudioId_nType ON [aa].[table] ([nStudioId],[nUserId],[nBrowseId],[dtCreateTime],[nType]) WITH (ONLINE=ON , MAXDOP=4,FILLFACTOR 阅读全文
摘要：
SELECT CONVERT(VARCHAR(10) , DATEADD(dd , number , '2021-08-25') , 120) AS dtDate INTO #tempDate FROM master..spt_values WHERE type = 'P' AND DATEADD( 阅读全文
2024年9月10日
