How to get number of days in a given year?

Answer Posted / satya

create function abc(@lpyr int)
returns int
As

returns 365+@udflpyr (@lpyr)

....
User Defined function is declared to find a leap yr

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can group functions be mixed with non-group selection fields in ms sql server?

620


Explain the properties of a relational table?

654


How to find the version of sql server? : sql server database administration

710


Explain identity in sql server?

643


What purpose does the model database server?

750






What is BLOCK statements in SQL?

893


How to sort the query output with order by clauses in ms sql server?

727


Do you know what are the steps to process a single select statement?

616


What is bcp? When does it use?

593


Explain sql delete command?

708


Difference between Sql server reporting services and Crystal reports?

132


What is an expensive query?

623


What is usually the first word in a sql query?

709


Can you please differentiate between a primary key and a unique key?

626


How do I make a resultset scrollable?

615