View Single Post
  #2 (permalink)  
Old February 23rd, 2006, 09:09 AM
SqlMenace SqlMenace is offline
Authorized User
 
Join Date: Sep 2005
Location: , , .
Posts: 95
Thanks: 0
Thanked 0 Times in 0 Posts
Default

A couple of ways

select month(getdate()) --2
select datepart(m,getdate()) --2
select datename(m,getdate()) --February
select month(CURRENT_TIMESTAMP) --2



“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" -- http://sqlservercode.blogspot.com/
Reply With Quote