Answer / Name

Subqueries can often be replaced with join statements to improve performance and readability. Instead of nesting queries, you can use the JOIN operator to combine data from multiple tables based on common columns.nnExample:n`SELECT Orders.OrderID, Customers.CustomerName FROM Orders INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID WHERE Customers.Country = 'USA';`

How to specify the collation for a character data type in ms sql server?

1 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

What are scalar functions?

1 Answers  

---

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1 Answers  

---

What is a data source file?

1 Answers  

---

About types of indexes in SQL server ?

2 Answers   Cognizant,

---

is it important for a database administrator to understand the operating system and file access? : Sql server administration

1 Answers  

---

What is dataset and its uses

2 Answers  

---

what is the importence of the trigger in sqlserver2000?

1 Answers   ATI,

---

what r steps to we need to fallow b4 kill the process?

1 Answers   Verizon,

---

What are SSL and TSL protocols?

1 Answers   Wipro,

---

In which files does sql server actually store data?

1 Answers  

---