摘要：-- 使用函数的方法：--建立 演示环境if object_id('tb_bookInfo') is not null drop table tb_bookInfogocreate table tb_bookInfo(number int,name varchar(10),type int)insert tb_bookInfoselect 1 ,'n1', 6 union allselect 2 ,'n2', 3if object_id('tb_bookType') is not null drop table tb_bookTy 阅读全文

摘要：DECLARE @LocalDate DATETIME,@UTCDate DATETIME,@LocalDate2 DATETIME SET @LocalDate = GETDATE()SET @UTCDate = DATEADD(hour, DATEDIFF(hour,GETDATE(),GETUTCDATE()), @LocalDate)SET @LocalDate2 = DATEADD(hour, DATEDIFF(hour,GETUTCDATE(),GETDATE()), @UTCDate) SELECT '1. Now' [Now], @LocalDate [Date 阅读全文