What is exclusive locks?

0 Answers  

---

What are the common performance issues in sql server?

0 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

What is bcp? When does it use?

0 Answers  

---

Define synonym?

0 Answers  

---

---

Mention the different types of replication in sql server.

0 Answers  

---

What is cursors? And what are the different types of cursor?

0 Answers  

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

Write a sql query to sort on different column name according to the parameters passed in the function?

0 Answers  

---

How do you troubleshoot SQL Server if its running very slow?

2 Answers   HP,

---

Distinguish between nested subquery and correlated subquery?

0 Answers  

---

What are the 3 types of schema?

0 Answers  

---