What is a derived table?

0 Answers  

---

What is difference between rownum and rowid?

0 Answers  

---

How to convert numeric values to integers in ms sql server?

0 Answers  

---

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

What are system databases into sql server (2005/2008) : sql server database administration

0 Answers  

---

Explain different forms of normalization?

0 Answers  

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

0 Answers  

---

Can we insert data if clustered index is disabled?

0 Answers  

---

How to use “drop” keyword in sql server and give an example?

0 Answers  

---

How to execute multiple stored procedures at one time in sql server?

0 Answers  

---

In performance wise distinct is good or group by is good? eg:select name from emp group by name; select distinct name from emp;

5 Answers   Infosys,

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

0 Answers  

---