What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

1135

---

What is the default port for SQL Server over a firewall?

1097

---

What is the syntax for encrypting a column in SQL Server?

1120

---

what is difference between NULL and ISNULL in SQL Server 2008?

1014

---

How to create a Master database in SQL server ?

1088

---

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1208

---

Difference between LEN() and DATALENGTH() in sql server ?

1104

---

Show Practically Sql Server Views are updatable?

1123

---

Define tool Manage Statistics in SQL Server 2000 query ?

1093

---

What is dynamic cursor in SQL SERVER?

1079

---

How you can change the database name in SQL SERVER?

1192

---

how we use window authentication connection with sql server.?

1152

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1145

---

Difference between connected and disconnected database in .net with sql server?

1095

---

Give the query of getting last two records from the table in SQL SERVER?

963

---