Answer / pratik

transfer data from sysdtspackages of msdb database to
another SQL Server

List the different types of joins?

0 Answers  

---

How do I create a stored procedure in dbml?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers  

---

Explain insert into select statement?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

What is 3nf normalization form?

0 Answers  

---

What are trace flags and mention a few common trace flags used with sql server?

0 Answers  

---

How to start and end transact-sql statements?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

explain the type of contraints

3 Answers  

---

What guidelines should be followed to help minimize deadlocks?

0 Answers  

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---