Answer Posted / prasanna

1.Inner Join
- Equi Join
- Natural Join
2.Outer Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
3.Cross Join
4.Self Join

What is normalization according to you and explain its different levels?

896

---

What is triggers in ms sql server?

1048

---

How to round a numeric value to a specific precision?

1011

---

what is create database syntax? : Sql server database administration

1052

---

Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

887

---

How to create a stored procedure with a statement block in ms sql server?

987

---

What happens if null values are involved in string operations?

919

---

Explain what is raid and what are different types of raid levels?

947

---

How to define output parameters in stored procedures?

958

---

How do I start sql server 2016?

856

---

While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?

933

---

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

975

---

What is default constraint in ms sql server?

965

---

How do I find the port number for sql server?

921

---

What are the new features in sql server 2016?

928

---