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

What is usually the first word in a sql query?

1131

Explain the truncate command?

977

What are the common performance issues in sql server?

925

What are date and time data types in ms sql server?

1089

How to create a local temporary stored procedure?

998

Why normalization is used?

1007

What is optimistic concurrency?

1036

Why use identity in sql server?

1095

What is collation sensitivity?

1056

In what version of sql server were synonyms released?

940

Define tempdb database?

992

Define magic tables in sql server?

1052

How to locate and take substrings with charindex() and substring() functions?

1016

What are the types of subscriptions in SQL Server replication?

1030

How do I know if localdb is running?

947