Willis.Lau的开发笔记

Select     CONVERT(varchar, getdate(), 1),--mm/dd/yy    CONVERT(varchar, getdate(), 2),--yy.mm.dd CONVERT(varchar, getdate(), 3),--dd/mm/yy     CONVERT(varchar, getdate(), 4),--dd.mm.yy     CONVERT(va

IF OBJECT_ID(tempdb.dbo.#T) IS NOT NULL DROP TABLE #T CREATE TABLE #T (ID VARCHAR(3),GID INT,Author VARCHAR(29),Title VARCHAR(39),Date DATETIME) INSERT INTO #T SELECT 001,1,邹建,深入浅出SQLServer20