what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

how we can use a database with php.

2 Answers   HCL, IT Solution,

---

What are 3 ways to get a count of the number of records in a table?

0 Answers  

---

What are a scheduled jobs?

0 Answers  

---

Explain transaction server implicit?

0 Answers  

---

What is the difference between varchar and nvarchar?

0 Answers  

---

What is Primary key and foreign key? Give an example

4 Answers   TCS,

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

What is the difference between system objects and user objects?

0 Answers   HCL,

---

What do you understand by a view?

0 Answers  

---

How to use group functions in the select clause in ms sql server?

0 Answers  

---