Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to delete multiple rows with one delete statement in ms sql server?
What is the difference between a view and a stored procedure?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Write the syntax for stuff function in an sql server?
Explain syntax for dropping triggers?
What do you understand by user-defined function in the sql server?
When is the use of update_statistics command?
How to execute a sql statement using odbc_exec()?
What do you mean by an execution plan? How would you view it?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is store procedure?
What are some examples of schemas?
Can you leave a union at any time?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
