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"
Answers were Sorted based on User's Feedback
Answer / newbie
CREATE PROCEDURE GetEventsByMonths
@MONTH VARCHAR(15)
AS
SET NOCOUNT ON
SELECT name,DATENAME(MONTH,startdate) AS Startmonth
FROM Events
WHERE DATENAME(MONTH,startdate) = @MONTH
GROUP BY name,DATENAME(MONTH,startdate)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / krishna mohan thamisetty
select datename(mm, startdate) startdate, datename(mm,
enddate) enddate, location from t1
Is This Answer Correct ? | 0 Yes | 2 No |
How you provide security to cube? : sql server analysis services, ssas
What is clustered vs nonclustered index?
Disadvantages of the indexes?
Explain different types of lock modes in sql server 2000?
What is Outter Join?
Explain how to use linked server?
Does hive support indexing?
How to manipulate data from one table to another table ?
wat new abt truncate in sql server
What is the contrast between sql and pl/sql?
Explain the etl (extraction, transformation, and loading)?
Explain about service Broker functions?