How to edit table in sql server 2017?

0 Answers  

---

Explain the relational database management system (rdbms)?

0 Answers  

---

What command must you use to include the not null constraint after a table has already been created?

0 Answers  

---

What are subqueries in sql server? Explain its properties.

0 Answers  

---

How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.

8 Answers   Intelenet,

---

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

create index a on employee(dno) In this,which index was created?

2 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

---

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

0 Answers  

---

How many database files are there in sql server 2000?what are they?

0 Answers  

---

How to create function with parameter in sql server?

0 Answers  

---

Explain having clause and where clause?

0 Answers  

---