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"
- 2 Answers
- 4356 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
How to maintain a fill factor in existing indexes?
Explain the database you used in your final year project?
What is #temp and @table variable in SQL server?
What is trigger explain with program?
How many types of cursor type are there?
What are acid properties of transaction?
What is isolation levels?
Can you please differentiate between a primary key and a unique key?
What is linked report?
Differentiate between SQL and ORACLE joins and write their syntax.
What are the new features of sql server 2008 r2 reporting service?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
can you instantiate a com object by using t-sql? : Sql server database administration
What the different types of Replication and why are they used?
What are logical database components? : SQL Server Architecture
