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

1079

---

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

1048

---

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

1073

---

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

980

---

How to create a Master database in SQL server ?

1042

---

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

1157

---

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

1069

---

Show Practically Sql Server Views are updatable?

1071

---

Define tool Manage Statistics in SQL Server 2000 query ?

1042

---

What is dynamic cursor in SQL SERVER?

1019

---

How you can change the database name in SQL SERVER?

1152

---

how we use window authentication connection with sql server.?

1102

---

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

1086

---

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

1052

---

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

913

---