List the ways in which dynamic sql can be executed?

0 Answers  

---

What is a trace frag?

0 Answers  

---

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

---

Can you explain what are various ways to enhance the ssrs report?

0 Answers  

---

Difference between server.transfer and server.execute method?

2 Answers  

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

Can foreign key be deleted?

0 Answers  

---

What is difference between view and materialized view?

0 Answers  

---

Explain about link server in sql server?

0 Answers  

---

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

0 Answers  

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

---