create function abc(@lpyr int) returns int As returns 365+@udflpyr

How to get number of days in a given year?

Question Posted / satya

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

Please Help Members By Posting Answers For Below Questions

Explain about Joins?

983

What is database replication? What are the different types of replication you can set up in sql server?

956

Distinguish between nested subquery and correlated subquery?

1037

When we should use and scope of @@identity?

995

While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

109

How do I debug a stored procedure in sql server?

1097

What is the server name in sql server?

1001

What are the steps to follow to configure SQL*Net?

1029

How to use the inserted and deleted pseudo tables?

955

Explain system scalar functions?

995

State a few properties of relational databases?

1120

What are the difference between primary key and unique key? : sql server database administration

936

Can you explain what is the use of custom fields in report?

1055

Explain how to maintain a fill factor in existing indexes?

990

How to run queries with sql server management studio express?

1082