SQL Server Knowledge Rollup

Select @ @servername -- Computer name Select @ @servicename -- Database name Select @ @version --  Select@ @language--

Configuration Functions

Select getdate() as getdate --Current TimeSelectgetUTCDate () asgetUTCDate--get UTC TimeSelect  Day(getdate()) as  Day --Remove DaySelect Month(getdate()) as Month --Take out the monthSelect  Year(getdate()) as  Year --Take out yearSelect DateAdd(d,3,getdate()) as DateAdd --Add three days, note that ' d ' represents the day, ' m ' represents the month, ' yy ' represents the year, as followsSelect DateDiff(d,'2004-07-01','2004-07-15') as DateDiff --calculates the difference of two timeSelect Datename(d,'2004-07-15') as Datename --Take out a part of the timeSelect DatePart(d,getdate()) as DatePart  --Take out a part of the time

Time Function

Print (' Debug Info ')

output Function

SQL Server Knowledge Rollup