Answer / Prabhat Kumar Mishra

You can use the INSERT INTO ... VALUES ...,... syntax to insert multiple rows using one Insert statement. Each set of values between the parentheses represents a single row.

How to test a dml trigger in ms sql server?

1 Answers  

---

what is a self join? : Sql server database administration

1 Answers  

---

sql server has its default date format in da form "yy-mm-dd" its possible to convert da current date format of sql server to desired format. Now my question is dat how to get da previous and comin days date in my desired format??

2 Answers  

---

What is reference section?

1 Answers  

---

select the 3rd maximum salary from sql server database if 4 (just an example In practically I may not know the exact situation) of the highest salaries are equal.

8 Answers   TCS,

---

Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance

10 Answers   IBM,

---

Mention the command used to rename the database.

1 Answers  

---

What are clustered and non-clustered index?

1 Answers  

---

What is a database table?

1 Answers  

---

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1 Answers   IBM,

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

1 Answers  

---

How do I view a stored procedure in sql server?

1 Answers  

---