Answer Posted / koppalahareesh
declare @y int;
set @y = 2016;
SELECT DATEDIFF(day,cast(@y as char(4)), cast(@y+1 as char(4))) Days
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What stored by the model?
What is the difference between a check constraint and a rule?
Do you know hot add cpu in sql server 2008?
What is the main purpose of having conversation group?
What is an identity column in insert statements?
How to store and query spatial data?
Can sql servers linked to other servers?
Where are sql server user names and passwords stored in sql server?
Is INSTEAD OF trigger directly applicable to Table ?
What is the use of tempdb? What values does it hold?
How to use go command in "sqlcmd"?
Determine how to use the inserted and deleted pseudo tables?
How to locate and take substrings with charindex() and substring() functions?
What are the methods used to protect against sql injection attack?
What are the purposes and advantages stored procedure?