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 are the three different part of rdl file explain them?

268

---

What are advantages of ssrs or why we should use ssrs?

139

---

how would you improve etl (extract, transform, load) throughput?

1028

---

What are different types of statement?

1018

---

According to you what goes into making the best database administrator? : sql server database administration

978

---

Explain “row_number()” in sql server with an example?

1004

---

How to create a dml trigger using create trigger statements?

1035

---

Explain cdc and sql injection?

982

---

What is federation member?

116

---

Define union, union all, minus, intersect?

980

---

How to retrieve error messages using mssql_get_last_message()?

1054

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

950

---

What function does a database engine serve in the sql server?

1041

---

Define synonym?

1176

---

How to use group functions in the select clause in ms sql server?

1055

---