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

Tell me what is fill factor?

1019

---

After removing a table from database, what other related objects have to be dropped explicitly?

1108

---

What is the use of set nocount on/off statement?

1152

---

What is lock escalation and what is its purpose?

1036

---

How to define output parameters in stored procedures?

1095

---

What are the advantages of log shipping?

1049

---

Why are you getting errors when creating a new odbc dsn?

1300

---

Differentiate between a local and a global temporary table?

1018

---

Can foreign key be duplicate?

1121

---

Why we use the openxml clause?

1059

---

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2127

---

What are scheduled tasks in sql server?

1163

---

Does table partitioning improve performance?

1019

---

What are ddl triggers and types of ddl trigger?

1105

---

How to use column default values in insert statements in ms sql server?

1108

---