Answer Posted / reventh

yes you can call a function.
sqlcommand cmd=new sqlcommand("select function
(parametter)");
sqldatareader rdr=cmd.excutereader();
while(rdr.read()
{
do something here;

}

How do you delete a trigger?

586

---

What does nvl stand for?

562

---

What are the mathematical functions supported by sql server 2005?

556

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

528

---

What are the 10 characteristics of data quality?

534

---

---

What is an indexing strategy?

538

---

Data table as parameter in sql server?

569

---

What are the different kinds of ssrs reports?

170

---

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

575

---

Explain table valued parameters in sql server? Why tvp used?

561

---

What is user defined datatypes and when you should go for them?

591

---

What triggers long term care?

565

---

What are a scheduled jobs?

538

---

Will count(column) include columns with null values in its count?

675

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

866

---