Answer Posted / d

insert into (table name) values(fieldname datatype);


for ex:

insert into emp values(eno number(3),ename varchar2(20));

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1122

---

your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration

960

---

What number aggregate functions are accessible there in sql?

1043

---

Can binary strings be converted into numeric or float data types?

1006

---

How do I view a stored procedure in sql server query?

911

---

Explain the difference between clustered and non-clustered index?

905

---

Does any body please help me what question's have asked for SSRS in the interview?

2129

---

What is forward - only cursors / read only cursor?

1071

---

Why I have to use stored procedures?

1017

---

What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

2042

---

What is deploy, process and build? : sql server analysis services, ssas

1084

---

Where cross join is used?

936

---

What stored by the model? : sql server database administration

934

---

how can u get last observation in an unknown dataset ?

2421

---

How data can be copied from one table to another table?

931

---