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

What is the difference between dbcc indexdefrag and dbcc reindex?

930

---

What are various limitations of the views?

997

---

What are the steps to insert a table?

892

---

What samples and sample databases are provided by microsoft?

976

---

How to create an multi-statement table-valued function?

939

---

is there a column to which a default can't be bound? : Sql server database administration

967

---

What are translations and its use? : sql server analysis services, ssas

993

---

What is an entity-relationship diagram (erd)?

1123

---

Can you please explain the difference between primary keys and foreign keys?

1057

---

What is a partition function in sql server?

1023

---

Which data type columns are the best candidates for full-text indexing?

917

---

How each E-R model constructs can be mapped to the relational model?

921

---

What is a natural primary key?

951

---

Where can you add custom error messages to sql server?

1054

---

Explain cursor as data base object?

974

---