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

1191

---

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

1147

---

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

1181

---

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

1060

---

How to create a Master database in SQL server ?

1148

---

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

1271

---

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

1175

---

Show Practically Sql Server Views are updatable?

1197

---

Define tool Manage Statistics in SQL Server 2000 query ?

1169

---

What is dynamic cursor in SQL SERVER?

1142

---

How you can change the database name in SQL SERVER?

1255

---

how we use window authentication connection with sql server.?

1217

---

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

1204

---

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

1153

---

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

1018

---