Answer Posted / vishal

1. Inner Join
2. Outer Join
- Left Outer Join
- Right Outer Join
- Full Outer Join
3. Cross Join

How many cores do I need for sql server 2016?

851

---

How to delete all rows with truncate table statement in ms sql server?

932

---

How to connect php with different port numbers?

1003

---

What are the two authentication modes in sql server?

1062

---

How to delete an existing database user?

970

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

922

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1325

---

What is the difference between ddl and dml?

1005

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

962

---

Describe triggers features and limitations?

928

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

823

---

Explain following error properties?

957

---

Why do we need normalization?

877

---

What is sql server database?

939

---

What are the 10 characteristics of data quality?

902

---