摘要:
View Code --把字符轉換成日期型declare @dt1 varchar(20)declare @dt2 varchar(20)set @dt1='2009-9-01'set @dt2='2009-10-01'if @dt1>@dt2 print 'dt1大'else print 'dt2大'if cast(@dt1 as datetime)>cast(@dt2 as datetime) print 'dt1大'else print 'dt2大'/*dt1大dt2大*/ 阅读全文