Answer / 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

What is the definition for sql server 2000?

1 Answers  

---

Do you know what is normalization of database? What are its benefits?

1 Answers  

---

What is difference between temp table and cte?

1 Answers  

---

i have a table student like sname ----- ram ram ram raj raj raj i need the output like sname ----- ram raj ram raj ram raj

9 Answers   IBM,

---

What are cursors and when they are useful?

1 Answers  

---

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

What are the properties of the transaction?

0 Answers  

---

Explain important index characteristics?

1 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

Explain about the command-line tool SQLCMD?

1 Answers  

---