Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajkumar
DECLARE @IsLeapYear BIT
SET @IsLeapYear = 0
IF (YEAR( @pDate ) % 4 = 0 AND YEAR( @pDate ) % 100 != 0) OR
YEAR( @pDate ) % 400 = 0
SET @IsLeapYear = 1
select 365 + @IsLeapYear
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Do you know what are pages and extents? : SQL Server Architecture
How can I tell if sql server is 32 or 64 bit?
What is a primary index?
Explain Reporting Life Cycle?
How to delete a login name in ms sql server?
what is a join and explain different types of joins? : Sql server database administration
How many types of triggers are there?
What is the advantage of sql server?
How to create new table with "create table" statements?
What are different types of statements that are supported by sql?
What are indexers?
Why normalization is used?
Explain about analysis services?
How to join two tables in a single query in ms sql server?
Create and insert into temp table in sql server?
