Answer Posted / akash

it will return the integer value of a variable

for example

intval(42); // 42
intval(4.2); // 4
intval('42'); // 42
intval('+42'); // 42

How to insert multiple rows with one insert statement in ms sql server?

582

---

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

557

---

What is a system database and what is a user database?

576

---

Do you know what is a trace frag? Where do we use it?

553

---

Explain sub-query?

569

---

---

What is the purpose of self join?

498

---

What is service broker? : sql server database administration

574

---

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1111

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

499

---

What are a scheduled jobs or what is a scheduled tasks?

492

---

How do I shrink an ldf file?

563

---

What is the difference between substr and charindex in the sql server?

508

---

What are tables in sql server?

529

---

What is the full meaning of dml?

523

---

Determine when an index is appropriate?

556

---