Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

There is table like Events...in that name ,startdate
,enddate,location are the column names
write a stored Procedure for this table to get events by
Months "GetEventsByMonths"

Answer Posted / krishna mohan thamisetty

select datename(mm, startdate) startdate, datename(mm,
enddate) enddate, location from t1

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

127


What is the difference between Normalization and De-normalization?

1153


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1878


What is advantage data architect?

979


How to modify the underlying query of an existing view?

1033


Can you move the resources after pausing the node? : sql server database administration

1172


What is difference between rownum and row_number?

1025


how to avoid cursors? : Sql server database administration

1022


What is the difference between seek predicate and predicate?

1117


What are the advantages of having an index on the sql server?

979


What is delete query?

1002


What is co-related sub query?

1080


How to rebuild master databse?

1134


How to get a list of columns using the "sys.columns" view in ms sql server?

1016


What is user-defined scalar function?

1010