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"
- 2 Answers
- 3284 Views
- I also Faced
- E-Mail Answers
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
What is the server name in sql server?
How many categories of data types used by sql server?
Can group functions be mixed with non-group selection fields in ms sql server?
In what three ways is the return statement used in a stored procedure?
What is the beast way to write CTE in SQL Server ?
How many database files are there in sql server 2000?what are they?
Explain the microsoft sql server delete command?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
How many types of triggers are there?
what types of replication are supported in sql server? : Sql server database administration
How to modify an existing stored procedure in ms sql server?
Explain what stored procedure sp_replcounters is used for? : sql server replication
Where are sql server usernames and passwords stored in the sql server?
Explain what is log shipping?
What is the sql profiler?
