Answer Posted / anil

just write DML sttements like insert into table1 values(),insert into table2 values()in stored procedure.By the way you can send multiple records at one time.

What is difference between stored procedure and user defined function?

1079

---

Explain few examples of stored procedure over triggers?

1010

---

Can we insert data into a view?

1117

---

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

885

---

How to select some specific columns from a table in a query in ms sql server?

986

---

What is the use of sign function?

1090

---

What are system databases into sql server (2005/2008)?

985

---

How can we improve performance by using SQL Server profiler?

1032

---

How to convert character strings into numeric values?

1077

---

What are parameterized reports? What are cascading parameters in ssrs reports?

156

---

Explain syntax for dropping triggers?

915

---

Comment,Datatypes are unlimited

2048

---

Explain how would you store your query in an SSRS report or a Database server?

126

---

How do I find sql server instance name?

946

---

Can you use order by when defining a view?

948

---