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 will you decide the active and passive nodes?
What is difference between drop truncate and delete?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
How do I find the sql server version?
What is transaction server implicit?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What are the disadvantages of primary key and foreign key in SQL?
What does the automatic recovery do?
What is a trigger in sql server?
What is Peer to peer Replication?
1 Answers CarrizalSoft Technologies, HCL,
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)