Answer Posted / akshay wadkar
DECLARE @year AS INT
SET @year=2010
Select DATEDIFF(DAY,DATEADD(YEAR,@year-1900,0)
,DATEADD(YEAR,@year-1900+1,0)) AS [TOTAL NO OF DAYS]
GO
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is "scheduled jobs" or "scheduled tasks"?
How to define the name and server for a new dsn?
How to count rows with the count(*) function in ms sql server?
What is checkpoint process in the sql server?
Where are full-text indexes stored?
What are the tools available in market as an alternative to sql server reporting services?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
How to generate create function script on an existing function?
What methods do you follow to protect from sql injection attack?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
how many layers of tcp/ip protocol combined of? : Sql server database administration
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
Can we use max in where clause?
What is data modification?
What does normalization do to data?