摘要:
SELECT T.ID , T.ADDRESS , T.CITY , T.POSTAL_CODE , T.STATE FROM dbo.LOCATION T WHERE EXISTS ( SELECT 1 FROM LOCATION WHERE ... 阅读全文
摘要:
DROP TABLE #temp; SELECT ID,ROW_NUMBER() OVER(ORDER BY DATE) AS row, REPLACE(NAME,'.pdf',RIGHT('0000'+CAST((ROW_NUMBER() OVER(ORDER BY DATE)) AS NVARCHAR(10)),4)+'.pdf') AS NAME INTO #temp FROM IMA... 阅读全文