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

What is for xml in sql server?

979


What is a trigger and its types?

929


What is meant by Active-Passive and Active-Active clustering setup?

1069


What are the basic features of a trigger in ms sql server?

1112


What is the purpose of forms?

909


What are the types of subquery?

989


What is the difference between count () and rowcount ()?

948


What is the maximum size per database for sql server express?

975


Explain the disadvantages of cursors?

1053


What are the advantages of using third-party tools?

921


Define candidate key, alternate key, and composite key.

874


How to name query output columns in ms sql server?

918


What is exporting and importing utility?

1018


What are out-of-range errors with date and time literals?

967


What is compression - row-level and page-level compression?

865